C
ChasW
I want to create a new table with the contents of 2 other tables whose
design specs are the same.
What would be the syntax to do this?
Right now, to get 1 query's results into a table I do something like:
SELECT tbl.* INTO tblNEW FROM tbl;
but what about from 2 sources? Is there a way to use UNION ALL in the
above statement?
Regards,
Charles
design specs are the same.
What would be the syntax to do this?
Right now, to get 1 query's results into a table I do something like:
SELECT tbl.* INTO tblNEW FROM tbl;
but what about from 2 sources? Is there a way to use UNION ALL in the
above statement?
Regards,
Charles