MySQL Forums
Forum List  »  Newbie

Re: What's the difference between left outer join and left join??
Posted by: laptop alias
Date: September 22, 2010 05:19AM

?
In MySQL LEFT JOIN and LEFT OUTER JOIN are identical. The OUTER keyword is optional.

You seem in fact to be comparing LEFT [OUTER] JOIN and FULL OUTER JOIN.

FULL [OUTER] JOIN is not a recognised construct in MySQL. You have to use a workaround with UNION instead.

Options: ReplyQuote


Subject
Written By
Posted
Re: What's the difference between left outer join and left join??
September 22, 2010 05:19AM


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.