UNION QUERY

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I have a question about UNION's.
If you have a SQL Union Query and you want to UNION it with another SQL
Union Query how would you do this? Is there a Sub-UNION?

Query 1
"code"
UNION
"code"
End Query 1
UNION ?????
Query 2
"code"
UNION
"code"
End Query 2

Doesn't this become confusing for Access? Or am I over thinking this?
 
DS said:
I have a question about UNION's.
If you have a SQL Union Query and you want to UNION it with another
SQL Union Query how would you do this? Is there a Sub-UNION?

Query 1
"code"
UNION
"code"
End Query 1
UNION ?????
Query 2
"code"
UNION
"code"
End Query 2

Doesn't this become confusing for Access? Or am I over thinking this?
Click to expand...

No and yes.
 
Back
Top