>-----Original Message----- >From: John Daisley [mailto:john.dais...@mypostoffice.co.uk] >Sent: Wednesday, February 04, 2009 10:41 AM >To: mysql@lists.mysql.com >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.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
