Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

If you join two tables that both have missing rows, you can combine the effect of a left and a right join by using a full join. The following figure shows the results of this query. Output from Fully ...