select productid from table1
union all
select productid from table2
union all
select productid from table3

------解决方案--------------------

SQL code
select distinct * from 
(
select productid from table1
union all
select productid from table2
union all
select productid from table3
) t