'where' clause at the end of all join

Viewed 101

Assuming that i have 2 sql query as below, will the query result ever be difference?

SELECT * FROM A
INNER JOIN B ON A.ID = B.ID
WHERE B.IsActive = 1
INNER JOIN C ON B.ID = C.ID
WHERE C.IsActive = 1

SELECT * FROM A
INNER JOIN B ON A.ID = B.ID
INNER JOIN C ON B.ID = C.ID
WHERE B.IsActive = 1 AND C.IsActive = 1
1 Answers
Related