![Alex Xu on Twitter: "Popular interview question: what's the difference between Inner, Left, Right, and Full join? The diagram below illustrates how different types of joins work. (INNER) JOIN: returns only matching Alex Xu on Twitter: "Popular interview question: what's the difference between Inner, Left, Right, and Full join? The diagram below illustrates how different types of joins work. (INNER) JOIN: returns only matching](https://pbs.twimg.com/media/FU5p2ekVEAEkR4D.jpg:large)
Alex Xu on Twitter: "Popular interview question: what's the difference between Inner, Left, Right, and Full join? The diagram below illustrates how different types of joins work. (INNER) JOIN: returns only matching
![left outer join in sql - sql - sql tutorial - learn sql - By Microsoft Awarded MVP - Learn in 30sec | wikitechy left outer join in sql - sql - sql tutorial - learn sql - By Microsoft Awarded MVP - Learn in 30sec | wikitechy](https://www.wikitechy.com/tutorials/sql/img/sql-images/join-types-representation.png)
left outer join in sql - sql - sql tutorial - learn sql - By Microsoft Awarded MVP - Learn in 30sec | wikitechy
![performance - MySQL: Which join is better between left outer join and inner join - Database Administrators Stack Exchange performance - MySQL: Which join is better between left outer join and inner join - Database Administrators Stack Exchange](https://i.stack.imgur.com/VQ5XP.png)