Difference between "and" and "where" in joins
Posted
by Midhat
on Stack Overflow
See other posts from Stack Overflow
or by Midhat
Published on 2010-04-01T08:52:56Z
Indexed on
2010/04/01
9:13 UTC
Read the original article
Hit count: 130
Whats the difference between
SELECT DISTINCT field1
FROM table1 cd
JOIN table2
ON cd.Company = table2.Name
and table2.Id IN (2728)
and
SELECT DISTINCT field1
FROM table1 cd
JOIN table2
ON cd.Company = table2.Name
where table2.Id IN (2728)
both return the same result and both have the same explain output
© Stack Overflow or respective owner
