From: Martijn Tonies (m.toniesupscene.com)
Date: Wed Feb 04 2009 - 10:08:12 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

> 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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]