[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: ON vs. WHERE
From:       Kévin_Labécot <kevin () labecot ! fr>
Date:       2008-01-30 22:24:35
Message-ID: 10B6EC27-079F-4590-9C39-87BD183F92E9 () labecot ! fr
[Download RAW message or body]

>>> -----Original Message-----
>>> From: Paul DuBois [mailto:paul@mysql.com]
>>> 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 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 conditional expression of the form that
>>> can be used in a WHERE clause. Generally, you should use the ON
>>> clause for conditions that specify how to join tables, and the WHERE
>>> clause to restrict which rows you want in the result set."
>>>
>> [JS] Thanks for that. I don't know where I read the opposite.  
>> Perhaps I was
>> passing a brain-stone.

Or maybe in a comment ? :p

-- 
Kévin Labécot
www.cv.labecot.fr


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql-marcsub@progressive-comp.com


[prev in list] [next in list] [prev in thread] [next in thread]