mysql> select * from beers; +----+-----------+--------+ | ID | name | colour | +----+-----------+--------+ | 1 | carlsburg | 2 | | 2 | tuburg | 1 | | 3 | tuburg | 9 | +----+-----------+--------+ 3 rows in set (0.00 sec)
mysql> select * from colours; +----+--------+ | id | colour | +----+--------+ | 1 | red | | 2 | green | | 3 | blue | +----+--------+ 3 rows in set (0.00 sec) mysql> select * from beers inner join colours on beers.colour = colours.ID; +----+-----------+--------+----+--------+ | ID | name | colour | id | colour | +----+-----------+--------+----+--------+ | 1 | carlsburg | 2 | 2 | green | | 2 | tuburg | 1 | 1 | red | +----+-----------+--------+----+--------+ 2 rows in set (0.00 sec) mysql> select * from beers outer join colours on beers.colour = colours.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 on beers.colour = colours.ID' at line 1 So I've gone looking the fine manual, here: http://dev.mysql.com/doc/refman/5.6/en/join.html The manual references natural outer joins and requires curly brackets and I'm frankly not making sense of it. Left, right, and inner joins work as I expect them too, and fishing for examples in google doesn't find anything unusual. How exactly am I erring? Thanks! -- Dotan Cohen http://gibberish.co.il http://what-is-what.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org