MySQL Forums
Forum List  »  General

Re: default JOIN
Posted by: Peter Brawley
Date: June 11, 2008 01:32PM

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

resolves to the same as

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

but when queries become more complicated, the latter syntax is far preferable for IS-SQL conformance, debugging & maintenance.

PB

Options: ReplyQuote


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