Hi all,
I also thinks that the options are not well written... Sorry for that 🙁 ..
My point of concern was to to throw light on different behaviors of AND and WHERE clause when use with LEFT and INNER JOIN..
--Query 1
SELECT
*
FROM table1 t1
LEFT JOIN table2 t2
on t1.id = t2.id AND t1.flag = 1
--Query 2
SELECT
*
FROM table1 t1
left JOIN table2 t2
on t1.id = t2.id
WHERE t2.flag = 1
If you execute these queries you will get same amount of rows in case of INNER JOIN while no of rows gets different when you put LEFT JOIN in this...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/