Something like:
Code:
Select  . . . from A
UNION ALL
Select  . . . from B
Where not exists
(select * from A
 where  A.id = B.id)