Order Details

Database error: Invalid SQL: SELECT ura_orders.order_id, entities.entity_name, ura_orders.order_date, ura_orders.order_notes, ura_orders.employee_id, ura_orders.order_status, SUM(order_line_amount) as order_total FROM entities JOIN ura_orders ON ura_orders.entity_id = entities.entity_id JOIN ura_order_details ON ura_order_details.order_id = ura_orders.order_id WHERE ura_orders.order_id = GROUP BY ura_orders.order_id nMySQL Error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY ura_orders.order_id' at line 6) nSession halted.