SQL SERVER - QUERIES - FROM CLAUSE - LEFT JOIN vs RIGHT JOIN HD

This tutorial covers the difference between using a LEFT JOIN or RIGHT JOIN. The differences are not as pronounced as between a LEFT JOIN and an INNER JOIN. It looks at all of the mistakes that newer developers can make when they fail to use an actual JOIN in the correct way. It also explains the pitfalls of when data becomes dirty.