select a query into a table

[ponneri]

Hi all.

I have a query that appends 5 tables with 2 columns of same name. The query runs fine.

But how do I move it into a new table with the select into option ?

I get an error that it does not work with an action query ?

Please help.

my query :

select order_id, part_num from a,
union all
select order_id, part_num from b,
union all
....... so on
till table e

 

[ponneri]

Thanks Pat.

I'll try that and see.