slecting all fields for a union query

J

jeanne

Hi, I have two queries i am unioning... is there a simple way to get all the
fields without having to type them all... something like select *.* from
[query a] union all *.* from [query b]
 
T

Ted Allen

Hi Jeanne,

You can use:

SELECT * FROM [query a]
UNION
SELECT * FROM [query B];

Or, you can use:

TABLE [query a]
UNION
TABLE [query b];

In either case, it will be important that the columns (fields) in the source
queries or tables be in the proper order, and also that there are the same
number of them.

HTH, Ted Allen
 
Top