Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3

Thread: Full Outer Join

  1. #1
    Regular Coder
    Join Date
    Sep 2002
    Location
    British Columbia
    Posts
    235
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Full Outer Join

    How can I run this query:
    PHP Code:
    SELECT Client.SurnameClient.GivenNames,
    Employee.SurnameEmployee.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

  • #2
    New Coder
    Join Date
    Nov 2002
    Location
    Netherlands
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.

  • #3
    Regular Coder
    Join Date
    Sep 2002
    Location
    British Columbia
    Posts
    235
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I figured. Grrrr.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •