Inner-join Index Page 1

Standard SQL:What is the difference between "INNER JOIN" and "OUTER JOIN"?

For beginners when learning JOIN it's a common error to ignore different types of JOIN. Some junior developers could use a wrong JOIN that looks like correct when it's not the case. Make sure you learn differences between LEFT JOIN and RIGHT JOIN