Paddy,

Please...What you have posted in not a problem.

Hope this helps.

select * from a
union
select * from b
where b.col1 not in ( select COL1 from a intersect select COL1 from b);

This will work considering the data pattern being the same as you have given in the example