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
 
Back
Top