Difference between INNER JOIN and FROM List in SQL

Question

What is the difference between theese queries?

SELECT * FROM table1 AS t1, table2 AS t2 WHERE t1.id = t2.id;

SELECT * FROM table1 AS t1 INNER JOIN table2 AS t2 ON t1.id = td.id;

which is faster?

possible duplicate of [INNER JOIN ON vs WHERE clause](http://stackoverflow.com/questions/1018822/inner-join-on-vs-where-clause) — AHiggins, Dec 18 '14 at 13:49

idstam · Answer 1 · 2014-12-18T13:35:35.090

2

The first is the same as an inner join.

An inner join will get all rows from both tables that matches the condition.

A left join will get all rows from the left table and all rows that match the condition from the right table.

After the edit of the question they are both the same.

edited Dec 18 '14 at 13:35

answered Dec 18 '14 at 13:26

idstam

So, if 1st is the same as inner, i made a little edit ;) – user3766478 Dec 18 '14 at 13:28
1

Then they are doing the same thing, in the same time. The first one is old style syntax, the second one is newer style syntax, preferred by many. – jarlh Dec 18 '14 at 13:35
1

Both are ANSI SQL. The first one original SQL-1 syntax, the second one "modern" SQL-2 syntax. – jarlh Dec 18 '14 at 13:37
@jarlh Thanks. I removed that part. – idstam Dec 18 '14 at 13:38

1 Answers1