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: 213

SELECT Table1.* ,Table2.Price AS Price
FROM
  Table1,Table2
WHERE
  Table1.ID = Table2.ID 

SELECT Table1.* ,Table2.Price AS Price
FROM 
  Table1 INNER JOIN Table2 ON Table1.ID = Table2.ID

© Stack Overflow or respective owner