MySQL Forums :: General :: default JOIN
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
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
| 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.
© 2013, Oracle Corporation and/or its affiliates