MySQL OUTER JOIN syntax error MySQL OUTER JOIN syntax error mysql mysql

MySQL OUTER JOIN syntax error


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


Try

SELECT * FROM company CLEFT JOIN company_address A ON C.company_id = A.company_idWHERE A.company_id IS NULL


You have to write LEFT JOIN,RIGHT JOIN,INNER JOIN or FULL OUTER JOIN instead of only OUTER JOIN.

There is also one error with your table name there shouldn't be space between the letters of a table like this [company C- it should be named as company_C]

I hope that will be work..All the best!