MySQL OUTER JOIN语法错误 [英] MySQL OUTER JOIN syntax error

问题描述

也许你们都喜欢用facepalm，但是作为SQL查询新手，我遇到了语法问题.有人知道怎么了吗?

Maybe a facepalm for you guys, but as a SQL query newbie, I'm having a syntax issue. Anyone know what's wrong?

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

推荐答案

在MySQL 中，您应该使用LEFT OUTER JOIN或RIGHT OUTER JOIN.不仅有外部联接.如果您需要MySql中的FULL OUTER JOIN 可以使用LEFT JOIN和RIGHT JOIN的UNION

In MySQL you should use LEFT OUTER JOIN or RIGHT OUTER JOIN. There is no just OUTER JOIN. If you need FULL OUTER JOIN in MySql you can use UNION of LEFT JOIN and RIGHT JOIN

这篇关于MySQL OUTER JOIN语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！