Full Outer Join

[Dylan Leblanc]

How can I run this query:SELECT Client.Surname, Client.GivenNames,
Employee.Surname, Employee.GivenNames
FROM Client FULL OUTER JOIN Employee
ON Client.EmployeeID=Employee.EmployeeID

FULL OUTER JOIN is not accepted!

http://www.mysql.com/doc/en/JOIN.html

[Wichetael]

FULL OUTER JOIN isn't yet supported by MySQL, it's still on the todo list, you can simulate it by doing two LEFT OUTER JOINs and combining the results.

[Dylan Leblanc]

I figured. Grrrr.