In SQL union remove the duplicated row, so did you try to debugging the second part of union by using an UNION ALL ?

Example

SELECT t1.id, t1.name, t1.city
FROM TEST1 AS t1
UNION ALL
SELECT t2.prod_id, t2.prod_desc, t2.location
FROM TEST2 AS t2;