List:General Discussion« Previous MessageNext Message »
From:(Hal Date:October 19 2011 4:55pm
Subject:Re: What is wrong with this outer join?
View as plain text  
;>>> 2011/10/19 17:00 +0200, Dotan Cohen >>>>
mysql> select * from beers b outer join colours c on (b.colour = c.ID);
ERROR 1064 (42000): 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 colours c on (b.colour = c.ID)' at line
1
<<<<<<<<
MySQL does not have real outer join, only left & right join. One means of getting
outer join is the union of left join and right join. (The words "INNER" and "OUTER" have
no real meaning in MySQL.)

Thread
What is wrong with this outer join?Dotan Cohen19 Oct
  • Re: What is wrong with this outer join?MySQL)19 Oct
    • Re: What is wrong with this outer join?Dotan Cohen19 Oct
      • Re: What is wrong with this outer join?MySQL)19 Oct
        • Re: What is wrong with this outer join?Dotan Cohen20 Oct
          • Re: What is wrong with this outer join?MySQL)20 Oct
            • Re: What is wrong with this outer join?Peter Brawley20 Oct
            • Re: What is wrong with this outer join?Dotan Cohen20 Oct
Re: What is wrong with this outer join?Dotan Cohen19 Oct
  • Re: What is wrong with this outer join?hsv20 Oct