;>>> 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.)
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org