slecting all fields for a union query

[Guest]

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]

 

[Guest]

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