Read this SQL tutorial to learn ... will omit duplicates between the tables unless the UNION ALL keyword is used. If your column names don’t match when you use the UNION statement, use aliases ...