query su più tabelle omogenee

[marketto]

http://dev.mysql.com/doc/mysql/en/UNION.html
"UNION is used to combine the result from many SELECT statements into one result set. UNION is available from MySQL 4.0.0 on."

SELECT * FROM pippo
UNION
SELECT * FROM pluto
UNION
SELECT * FROM paperino