SQL SERVER – Simulate INNER JOIN using LEFT JOIN statement – Performance Analysis | Journey to SQL Authority with Pinal Dave

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 INNER JOIN using any other JOINs will degrade the… Continue Reading...

Source: SQL SERVER – Simulate INNER JOIN using LEFT JOIN statement – Performance Analysis | Journey to SQL Authority with Pinal Dave