prova con

SELECT * FROM ACCOUNT
INNER JOIN
( SELECT UID FROM PIPPO
UNION ALL
SELECT UID FROM
PLUTO
UNION ALL
SELECT UID FROM
PAPERINO ) T1
ON
ACCOUNT.uid = T1.uid