MySQL error. Error Code: 1064

SQL
1

Hello,

Am learning the Inner and Outer Joins and I have experienced this error below on 2 occasions while running the query below.

SELECT
c.customer_id,
c.first_name,
o.order_id,
FROM customers c
JOIN orders o
ON c.customer_id = o.customer_id
ORDER BY c.customer_id

I got Error Code: 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 ‘FROM customers c JOIN orders o ON c.customer_id = o.customer_id ORDER BY c.custo’ at line 5

How Do I solve this.

Thanks in Advance

2

The comma after order_id is the problem. MySQL is expecting another column definition after the comma.

3

Thanks Sam, It worked.