RE: WHERE vs. ON

[Jerry Schwartz]

>-----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.