Link to home
Start Free TrialLog in
Avatar of ol muser
ol muserFlag for United States of America

asked on

using keyword inner join

Is there any specific advantage in using the keyword inner join in a query instead of just saying tab1.col1 = tab2.col1? Performance issues? SQL standard?
Avatar of schubach
schubach

Reference https://www.experts-exchange.com/questions/27737675/Should-I-be-using-JOINs-rather-than-ANDs-in-my-SELECT-statement.html

http://stackoverflow.com/questions/1018822/inner-join-on-vs-where-clause has a very good discussion.  

The short answer is that you should use JOIN.  It is more readable and depending on your database may run more quickly.
ASKER CERTIFIED SOLUTION
Avatar of Joe Woodhouse
Joe Woodhouse

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ol muser

ASKER

thanks for the Sybase specific answer