From: Martijn Tonies
Date: February 4 2009 4:08pm
Subject: Re: WHERE vs. ON
List-Archive: http://lists.mysql.com/mysql/216159
Message-Id: <017201c986e2$c74d90d0$1401a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit



> 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