Simple SQL Join Understanding?
database, mysql, sql, sql-server, sql-server-2008
Solution
The second version, with the explicit `JOIN` and join condition is standardized SQL.
The implicit join syntax with a `WHERE` clause is deprecated syntax (or, rather, considered bad) - partially because it is easy to forget the `WHERE` clause and cause a Cartesian product.
Problem
Possible Duplicate: Explicit vs implicit SQL joins Is there a difference using join andselect from multi-tables? SQL Joins: Future of the SQL ANSI Standard (where vs join)? What is the difference between JOIN and declaring multiple tables in the FROM clause? Such as: ``` SELECT * FROM table1 AS t1, table2 AS t2 WHERE t1.id = t2.id ``` Compared to: ``` SELECT * FROM table1 AS t1 INNER JOIN table2 AS t2 ON t2.id = t1.id ```