List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:February 4 2009 4:08pm
Subject:Re: WHERE vs. ON
View as plain text  

> 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
Thread
WHERE vs. ONJerry Schwartz3 Feb
  • RE: WHERE vs. ONMartin Gainty3 Feb
    • RE: WHERE vs. ONJerry Schwartz3 Feb
      • Re: WHERE vs. ONRob Wultsch3 Feb
  • Re: WHERE vs. ONPerrin Harkins3 Feb
  • Re: WHERE vs. ONBaron Schwartz4 Feb
    • RE: WHERE vs. ONJerry Schwartz4 Feb
    • Re: WHERE vs. ONJohn Daisley4 Feb
      • RE: WHERE vs. ONJerry Schwartz4 Feb
    • Re: WHERE vs. ONClaudio Nanni4 Feb
  • Re: WHERE vs. ONMartijn Tonies4 Feb