There is not an either/or situation with join and union. join is used to combine 2 or more tables into a single virtual table with a set of columns from both tables.

UNION is used to combine the results of 2 separate SELECTS into a single rowset (or ADO RECORDSET).