我有一个MySQL中使用的FULL JOIN关键字的问题
SELECT Name,Surname,Notes.Payment FROM Persons FULL JOIN Notes ON Persons.id=Notes.P_Id
它给了我这个错误:
Unknown column 'Persons.id' in 'on clause'
,但如果我调用左JOIN或右JOIN,结果显示正确。
FULL JOIN有什么问题?
谢谢
MySQL不支持FULL JOIN
像这样使用:
SELECT Name, Surname, Notes.Payment
FROM Persons
LEFT JOIN Notes
ON Persons.id = Notes.P_Id
UNION ALL
SELECT Name, Surname, Notes.Payment
FROM Persons
RIGHT JOIN Notes
ON Persons.id = Notes.P_Id
WHERE Persons.id IS NULL
得到的错误是因为FROM Persons FULL JOIN Notes ON
被解析为:
FROM Persons AS FULL
JOIN Notes
ON ...