![SQL SERVER - Interesting Observation of ON Clause on LEFT JOIN - How ON Clause affects Resultset in LEFT JOIN - SQL Authority with Pinal Dave SQL SERVER - Interesting Observation of ON Clause on LEFT JOIN - How ON Clause affects Resultset in LEFT JOIN - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/LeftJoinON4.jpg)
SQL SERVER - Interesting Observation of ON Clause on LEFT JOIN - How ON Clause affects Resultset in LEFT JOIN - SQL Authority with Pinal Dave
![SQL SERVER - Interesting Observation of ON Clause on LEFT JOIN - How ON Clause affects Resultset in LEFT JOIN - SQL Authority with Pinal Dave SQL SERVER - Interesting Observation of ON Clause on LEFT JOIN - How ON Clause affects Resultset in LEFT JOIN - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/LeftJoinON1.jpg)
SQL SERVER - Interesting Observation of ON Clause on LEFT JOIN - How ON Clause affects Resultset in LEFT JOIN - SQL Authority with Pinal Dave
![SQL SERVER - INNER JOIN using LEFT JOIN statement - Performance Analysis - SQL Authority with Pinal Dave SQL SERVER - INNER JOIN using LEFT JOIN statement - Performance Analysis - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/leftinner.gif)