How Can I join Two Queries?

  • Thread starter Thread starter alex
  • Start date Start date
A

alex

I have two queries that have similar information that I want to combine into
only one query or file so I can use in a report. I have tried several queries
to combine that information but nothing has worked so far. Does anyone know
how I can combine both queries into only one? (basically I want Query 1 &
Query 2 to join and become one master query with all the information)
 
Great thank you for the tip, but how can I do this using a UNION query? Can
you give me an example on the correct format to use with the fields below.

TABLE A TABLE B

Item# Item#
Description Description
Price Price
 
SELECT [Item#], Description, Price
FROM [Table A]
UNION ALL SELECT [Item#], Description, Price
FROM [Table B];
 
Back
Top