Hi, did You think something like this??

select col1, col2, 'TAB1' from tab1
union
select col3, col4, 'TAB2' from tab2

???

Tom