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