Question

This question already has an answer here:

MySQL Inner Join Query Syntax error (1 answer)

Closed 11 hours ago.

diver

这就是:

SELECT id_membre, id_sortie, id_diver, licence, mail, actif
FROM inscription
WHERE id_sortie = 4071

当我加入LEFT JOIN时,它坠毁:

SELECT id_membre, id_sortie, id_diver, licence, mail, actif
FROM inscription
WHERE id_sortie = 4071
LEFT JOIN diver ON inscription.licence = diver.licence;

#1064 - You have an wrong in You syntax;eck the本手册相当于您的MySQL服务器版本,供右辛子使用,靠近LEFT JOIN diver的登记。许可证 = 第3条()项中的第0、30条

Answer 1

Correct syntax :

SELECT id_sortie, id_diver, inscription.licence, mail, actif
FROM inscription
LEFT JOIN diver ON inscription.licence = diver.licence
WHERE inscription.id_sortie = 4071;

友情链接