I'm trying to INNER JOIN the 'order' table and the 'customer' table but its not working. The common field is 'cus_id'. Here is my INNER JOIN code:
SELECT *
FROM customer
INNER JOIN order ON customer.cus_id = order.cus_id;
Order is key word of mysql . make it enclosed by back ticks
SELECT *
FROM customer
INNER JOIN `order` ON customer.cus_id = order.cus_id;