con mySQL >= 4.0.0
codice:
SELECT * FROM tabella1
UNION
SELECT * FROM tabella2
ORDER BY campo3 DESC LIMIT 0,3