Are these two select sql statements equal? "join...on" vs. "where"

Question

Are the following two select SQL statements exactly equal? I usually use the join keyword, but I found that the sqlite author uses the second form in some of his document pages on sqlite.org.

The "inner join...on" form

SELECT * FROM Order INNER JOIN OrderItem ON Order.Id = OrderItem.ParentId

The "where" form

SELECT * FROM Order, OrderItem WHERE Order.Id = OrderItem.ParentId

Update 1: I found this question might be duplicated, it seems has something to do with the SQL89 and SQL92 standards, but it doesn't answer me the second form is an "INNER JOIN", "OUTER JOIN" or anything else.

score 1 · Accepted Answer · edited May 23 '17 at 12:18

1

Result will be the same but there are separate purpose of each syntax. for more details check this inner join vs where

edited May 23 '17 at 12:18

Community

1
1

answered Apr 17 '17 at 05:57

Ravindra

210
3
13

score -1 · Answer 2 · answered Apr 17 '17 at 05:58

If you talk about specifically the query you mentioned then yes both will result the same but join and where clause don't give same results. join is used for joining two tables and where clause is further used to specify the data selection from those tables.

Are these two select sql statements equal? "join...on" vs. "where"

2 Answers2