List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:February 4 2009 4:00pm
Subject:RE: WHERE vs. ON
View as plain text  

>-----Original Message-----
>From: John Daisley [mailto:john.daisley@stripped]
>Sent: Wednesday, February 04, 2009 10:41 AM
>To: mysql@stripped
>Cc: Jerry Schwartz
>Subject: Re: WHERE vs. ON
>
>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?
[JS] No, there is no "(+) in MySQL.



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