Never tried it in MySQL and Im not in a position to do so at the moment but in Oracle you can do a left outer join in the where clause something like this SELECT t1.col1, t2.col2 FROM table1 t1, table2 t2 WHERE t1.join_col_name = t2.join_col_name(+) Does this not work in MySQL?
Luckily, it does not. And since Oracle 8, it supports the standard syntax with JOIN.
Never tried it because I prefer my joins to be done in the FROM clause using 'JOIN.....ON....' or 'JOIN.....USING.....'
As it should be :-) With regards, Martijn Tonies Upscene Productions FREE "Database Workbench Lite for MySQL" at http://www.upscene.com Database questions? Check the forum: http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
