为什么这个INNER JOIN不起作用？

Question

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;

'customer' table

'order' table

Answer 1

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;