A UNION call by itself will only return distinct records, meaning if there are identical records in Table1 and Table2, only one record will be returned.
A UNION ALL says give me all the records, even the duplicate.