SQL SERVER – Simulate INNER JOIN using LEFT JOIN statement – Performance Analysis | Journey to SQL A

Just a day ago, while I was working with JOINs I find one interesting observation, which has prompted me to create following example. Before we continue further let me make very clear that INNER JOIN should be used where it can not be used and simulating

blog.sqlauthority.com