The LEFT JOIN command is the most commonly used external join command. It lists all elements common to two tables, as well as all elements in the left-hand table (the table following FROM). Let's consider two tables: Table1 and Table2, with Table1 being the left-hand table. The LEFT JOIN will list all results from the left-hand table (Table1), even if there is no correspondence between the two tables.