Languages

MySQL - how to do FULL OUTER JOIN?

0 points
Asked by:
Marcino
360

Is it possible to do a FULL OUTER JOIN in MySQL? I tried SQL syntax but it doesn't seem to work.

My query:

SELECT * FROM `users`
FULL OUTER JOIN `departments` 
ON `departments`.`id` = `users`.`department_id`;

Error:

MySQL - FULL OUTER JOIN error (HeidiSQL)
MySQL - FULL OUTER JOIN error (HeidiSQL)
0 answers
Native Advertising
🚀
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

❤️💻 🙂

Join