You can use UNION when you have two tables you want to combine
but that contain different data.

You will have to make the two tables agree before you can do the UNION though, this is done by making the
final table contain all information from all tables with NULL entries in the rows that don't
have the data required.