Alex Xu on X: "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
SQL - Difference Between INNER JOIN and JOIN - SQL Authority with Pinal Dave
SQL Joins - Inner, Left, Right, Self, Cross, and Full