MySQL Forums
Forum List  »  Newbie

Re: Select * From t1,t2 ON a=b problem
Posted by: Walter Heck
Date: March 16, 2009 12:32PM

ON is only used in conjunction with a JOIN (whichever type of join you want)
so, for example:

select
a
from
table1 as X left join table2 as Y on X.field1 = y.field1;

So, decide which kind of join you want (probably left or inner) and use that :)

Options: ReplyQuote


Subject
Written By
Posted
Re: Select * From t1,t2 ON a=b problem
March 16, 2009 12:32PM


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.