Re: ON vs. WHERE

2008-01-30 Thread Kévin Labécot
-Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 30, 2008 11:50 AM To: Jerry Schwartz; mysql@lists.mysql.com Subject: Re: ON vs. WHERE At 11:46 AM -0500 1/30/08, Jerry Schwartz wrote: The documentation says (I think) that you should not use an ON

Re: ON vs. WHERE

2008-01-30 Thread Les Fletcher
tbl1.col1=tbl2.col2; Does switching up the on from and the join change the driving table? Les Jerry Schwartz wrote: -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 30, 2008 11:50 AM To: Jerry Schwartz; mysql@lists.mysql.com Subject: Re: ON vs. WHERE

RE: ON vs. WHERE

2008-01-30 Thread Jerry Schwartz
> -Original Message- > From: Paul DuBois [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 30, 2008 11:50 AM > To: Jerry Schwartz; mysql@lists.mysql.com > Subject: Re: ON vs. WHERE > > At 11:46 AM -0500 1/30/08, Jerry Schwartz wrote: > >The documentation say

Re: ON vs. WHERE

2008-01-30 Thread Paul DuBois
At 11:46 AM -0500 1/30/08, Jerry Schwartz wrote: The documentation says (I think) that you should not use an ON join condition when you can use a WHERE, but I'm pretty sure someone from MySQL.com posted a message suggesting the opposite. The manual says this: "The ON conditional is any conditi

ON vs. WHERE

2008-01-30 Thread Jerry Schwartz
The documentation says (I think) that you should not use an ON join condition when you can use a WHERE, but I'm pretty sure someone from MySQL.com posted a message suggesting the opposite. Aside from LEFT JOINs, which require an ON, does anyone have any opinions or experience? Regards,