MySQL multiple Inner Join 帮助 - 1064

Question

也许是深夜，或者我没有喝足够的咖啡，但我似乎无法理解为什么我的 MySQL 语句是 1064'ing。

伪代码:

Get the id of the latest event happening, then join it with all guests that are linked (attending) that event retrieving their first and second names.

数据库

SELECT event.id, link.event_id, link.guests_id, guests.id, guests.first_name, guests.second_name 
FROM event
INNER JOIN link
ON event.id =link.event_id;
INNER JOIN guests
ON link.guests_id = guest.id;
ORDER BY event.date DESC 
LIMIT 1

谢谢!

Answer 1

从语句中删除 ; 以使其工作。

; 是分隔符，数据库引擎认为您的查询在 ; 上结束并且不完整