INNER JOIN keywords | with and without using them
Posted
by cedar715
on Stack Overflow
See other posts from Stack Overflow
or by cedar715
Published on 2010-04-16T10:27:34Z
Indexed on
2010/04/16
10:33 UTC
Read the original article
Hit count: 221
SELECT * FROM TableA
INNER JOIN TableB
ON TableA.name = TableB.name
SELECT * FROM TableA, TableB
where TableA.name = TableB.name
Which is the preferred way and why? Will there be any performance difference when keywords like JOIN is used?
Thanks
© Stack Overflow or respective owner