Insert into a table selecting data from a sub query
Add some alias:

insert into mytable (columns) 
select t.* from (
    select columns from tableA 
    UNION ALL
    select columns from tableB
    UNION ALL
    select columns from tableC
) t