MySQL Forums
Forum List  »  Newbie

Re: Select * From t1,t2 ON a=b problem
Posted by: Guelphdad Lake
Date: March 17, 2009 09:21AM

The docs say you can use a comma and often do use commas. It is one of the worst things about the docs in my opinion (particularly since mysql 5 syntax is more strict about mixing join and comma join syntaxes).

Stick to labelling your joins INNER or LEFT OUTER or CROSS where necessary.

Options: ReplyQuote


Subject
Written By
Posted
Re: Select * From t1,t2 ON a=b problem
March 17, 2009 09:21AM


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.