MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: JOIN, and LEFT OUTER JOIN: I don't get it
Posted by: Rick James
Date: March 13, 2011 01:57PM

> Any conditions on the right hand table belong in the ON clause and not the WHERE clause.
Except when you are trying to get only the missing rows:
WHERE right_table.id IS NULL

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
JOIN, and LEFT OUTER JOIN: I don't get it
Olivier Dofus
March 13, 2011 05:17AM
Re: JOIN, and LEFT OUTER JOIN: I don't get it
Guelphdad Lake
March 13, 2011 09:29AM
Re: JOIN, and LEFT OUTER JOIN: I don't get it
Rick James
March 13, 2011 01:57PM
Re: JOIN, and LEFT OUTER JOIN: I don't get it
Gints Plivna
March 14, 2011 04:33AM
Re: JOIN, and LEFT OUTER JOIN: I don't get it
Rick James
March 14, 2011 08:10AM
Re: JOIN, and LEFT OUTER JOIN: I don't get it
Gints Plivna
March 14, 2011 08:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.