create view qtemp.myview1 as Select ...from ... where ...
UNION ALL
Select ... from ... where ...

Fehlt ALL, werden Duplikate ausgeblendet.