union query using query

S

Souris

May I use query inside my union query or I must use table in my union query?

For example, my I use

select MyField from myQuery1
union
select MyField from myQuery2

Both my queries have parameters

or I have to do


select MyField from MyTable1
union
select MyField from MyTable2


Your information is great appreciated,
 
K

KARL DEWEY

May I use query inside my union query or I must use table in my union query?
You do not need anyone's permission to try it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

union query precision issue 6
Union query 5
insert a crosstab in to temp table query 2
SUM in a UNION query 2
sub query 3
determining if a field should be included 6
Union Query and Field Alias 7
Union Query 1

Top