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