Is there a difference using join andselect from multi-tables?
Posted
by nemiss
on Stack Overflow
See other posts from Stack Overflow
or by nemiss
Published on 2010-04-07T13:49:01Z
Indexed on
2010/04/07
13:53 UTC
Read the original article
Hit count: 192
Filed under:
sql
First option:
SELECT Table1.* ,Table2.Price AS Price
FROM
Table1,Table2
WHERE
Table1.ID = Table2.ID
Second option:
SELECT Table1.* ,Table2.Price AS Price
FROM
Table1 INNER JOIN Table2 ON Table1.ID = Table2.ID
Which one is better and most efficient?
© Stack Overflow or respective owner
