Understanding UNION in MySQL March 12, 2018 Assuming there are tables EMP and EMP2, which have the same schema, and there are possible duplicate IDs present in them???the following query will help us identify the unique records: