Using Where and on keywords for checking conditions in Select statements

Question

Whats the difference between using On and Where keywords in a Sql query to check conditions.

select * from child_table inner join parent_table p on p.id>0;

select * from child_table inner join parent_table p where p.id>0;

Both these queries are providing me the same result

They are equivalent statements, but the first is correct SQL. The second only works in MySQL and looks like a bastardization of the language. `INNER JOIN` should always have an `ON` clause. — Gordon Linoff, Oct 26 '15 at 01:02

score 0 · Answer 1 · edited May 23 '17 at 12:03

0

WHERE is a part of the SELECT query as a whole. And ON is a individual join.

See this Post.

edited May 23 '17 at 12:03

Community

answered Oct 26 '15 at 08:19

BRoebie

1 Answers1