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

Reference 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.
Avatar of Joe Woodhouse
Joe Woodhouse

Link to home
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


thanks for the Sybase specific answer