Combining multiple select queries into one select

  • Thread starter Thread starter Andrea
  • Start date Start date
A

Andrea

I am trying to combine multiple select queries into one
select query, but I am not getting the results that I
want. Any tips for this process?
 
Completely depends upon what you mean by "Combine". Do you mean that you
want to have records from all the queries show in one query? If yes, you
want a UNION query:

Selectquery1 SQL Statement

UNION ALL Selectquery2 SQL Statement

UNION ALL Selectquery3 SQL Statement


Note that there must be the same number of fields in all queries, and the
first fields must all be formatted the same, the second fields must all be
formatted the same, etc.
 
Back
Top