SELECT A, B FROM FOO WHERE ...
UNION
SELECT C as A, D as B FROM BAR WHERE ...