5 Queries 2

[ncopeland]

Hi

I have 5 queries. I want to be able to run these queries one after another and then join them into one list of records. Can anybody suggest a way of doing this.

KR

NC

 

[koresnordic]

Do they all produce the same set of fields in the results?

If som use the first as a make table query and the rest as update



Graham

 

[r937]

sounds like you want a UNION of the 5 queries

r937.com | rudy.ca

 

[ncopeland]

Hi Guys yes each query uses the exact same fields. I am not sure how to put the union statement together.

KR

NC

 

[r937]

you can put the union query together like this --

query 1 goes here
union all
query 2 goes here
union all
query 3 goes here
union all
query 4 goes here
union all
query 5 goes here



r937.com | rudy.ca

 

[ncopeland]

Hi

Bit of a novice with sql this is my union query.

SELECT qselIngredientsQTYREC1.*,
UNION ALL
SELECT qselIngredientsQTYREC2.*,
UNION ALL
SELECT qselIngredientsQTYREC3.*,
UNION ALL
SELECT qselIngredientsQTYREC4.*,
UNION ALL
SELECT qselIngredientsQTYREC5.*

Tried this but it didn't work. Any ideas.

KR

NC

 

[r937]

remove the commas

r937.com | rudy.ca

 

[ncopeland]

Hi

When i run this I get

Query input must contain one query or table.

Any ideas.

KR

NC

 

[r937]

the only idea i get from that message is that you didn't run the union query properly

r937.com | rudy.ca

 

[PHV]

And what what about this ?
SELECT * FROM qselIngredientsQTYREC1
UNION ALL
SELECT * FROM qselIngredientsQTYREC2
UNION ALL
SELECT * FROM qselIngredientsQTYREC3
UNION ALL
SELECT * FROM qselIngredientsQTYREC4
UNION ALL
SELECT * FROM qselIngredientsQTYREC5

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[r937]

man, i can't believe i didn't see that bad syntax

nice one, phv



r937.com | rudy.ca