MySQL Forums :: General :: default JOIN

Advanced Search

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.


Options: ReplyQuote

Subject Written By Posted
default JOIN samit jain 06/11/2008 12:30PM
Re: default JOIN Peter Brawley 06/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.