[friz]

Какое субд?Может так?

Код:

INSERT INTO TABLE_ALL (field1,field2,field3) VALUES 
(
SELECT field1,field2,field3 FROM TABLE1
UNION ALL
SELECT field1,field2,field3 FROM TABLE2
UNION ALL
SELECT field1,field2,field3 FROM TABLE3
)