也许对你们来说是一个捂脸,但作为一个 SQL 查询新手,我遇到了语法问题。有谁知道出了什么问题吗?
SELECT * FROM company C
OUTER JOIN company_address A ON C.company_id = A.company_id
WHERE A.company_id IS NULL
给出错误:
#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
'OUTER JOIN company_address A ON C.company_id = A.company_id WHERE A.address_id
' at line 2
In MySQL http://dev.mysql.com/doc/refman/5.0/en/join.html你应该使用LEFT OUTER JOIN
or RIGHT OUTER JOIN
。没有公正的OUTER JOIN
。如果你需要FULL OUTER JOIN
在MySql中您可以使用UNION of LEFT JOIN and RIGHT JOIN https://stackoverflow.com/questions/4796872/full-outer-join-in-mysql
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)