Re: What is wrong with this outer join?

[(Hal]

;>>> 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.)