> 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
