}

Outer-join Index Page 1

mysql database join inner-join outer-join

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