Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Martijn Tonies (m.toniesupscene.com)
Date: Wed Feb 04 2009 - 10:08:12 CST
> 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 :-)
FREE "Database Workbench Lite for MySQL" at
Database questions? Check the forum:
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql