Union query question

  • Thread starter Thread starter stuart reicher
  • Start date Start date
S

stuart reicher

Below is my union query

Select * from [FA Production Report For A Manager]
UNION ALL Select * from [ENV Production Report For A
Manager];

Can I do anything that will allow data to show up if one
of the two queries has no data after it is run?? Right
now unless there is data in both queries nothing will
show up.
 
stuart said:
Below is my union query

Select * from [FA Production Report For A Manager]
UNION ALL Select * from [ENV Production Report For A
Manager];

Can I do anything that will allow data to show up if one
of the two queries has no data after it is run?? Right
now unless there is data in both queries nothing will
show up.
Click to expand...

Use UNION instead of UNION ALL
 

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 5
Show data source in Union Select All Queries 2
Union Query 2
Comlex union query question 4
Union Query and Field Alias 7
union query 4
Losing Records Between Union Query and Select Query 3
Union Query of Two Queries (Part 2) 2

Back
Top