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

Filed under:
|
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

Related posts about sql

Related posts about joins