J
jt
I wrote and can run this querry:
sELECT a.*
from students_r8793 a
union all
select b.*
from students_r8940 b
UNION ALL select c.*
from students_r8941 c;
runs fine and gets the correct results but when I try to create a new
table with the results by doing
sELECT a.* into students_r8793_and_r8940_and_r8941
from students_r8793 a
union all
select b.*
from students_r8940 b
UNION ALL select c.*
from students_r8941 c;
I get an error "An action query cannot be used as a row source" and I'm
sure what this error message is telling me.or how to do what I want to
do.
Thanks for any quidence.
Jack
sELECT a.*
from students_r8793 a
union all
select b.*
from students_r8940 b
UNION ALL select c.*
from students_r8941 c;
runs fine and gets the correct results but when I try to create a new
table with the results by doing
sELECT a.* into students_r8793_and_r8940_and_r8941
from students_r8793 a
union all
select b.*
from students_r8940 b
UNION ALL select c.*
from students_r8941 c;
I get an error "An action query cannot be used as a row source" and I'm
sure what this error message is telling me.or how to do what I want to
do.
Thanks for any quidence.
Jack