MySQL Forums
Forum List  »  General

default JOIN
Posted by: samit jain
Date: June 11, 2008 12:30PM

Hi,
Will this query do an INNER Join (or NATURAL Join) by default if I have keys on the join columns?

select * from T1,T2 where T1.c1=T2.c1

or do I have to explicitly specify:

select * from T1 INNER JOIN T2 ON T1.c1=T2.c1

Is there any difference between the above statements?

thanks,
Samit

Options: ReplyQuote


Subject
Written By
Posted
default JOIN
June 11, 2008 12:30PM
June 11, 2008 01: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.