Combine two tables of data into one query (1 Viewer)

[Number11]

So i have two large tables of data - in fact linked excel spreadsheets that hold serial number for equipment one table hold xx manufacture and the other another xxx manufacture both tables have the sam field name i want to use

Manufacture_Date
Serial_Number
Last_ImpectionDate

need to have all the data in one new query so i can pull in this data using just the Serial Number but have just one pass against all data

 

[plog]

Most likely you want a UNION query:

SQL UNION Operator

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

www.w3schools.com

 

[Number11]

Most likely you want a UNION query:

SQL UNION Operator

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

www.w3schools.com

Ok thanks so i can do that on all 3 fields in the two tables then?

 

[Minty]

A union query is the answer.

Select "xxx" as Manu , Manufacture_Date , Serial_Number , Last_ImpectionDate FROM tableXXX

UNION

Select "yy" as Manu , Manufacture_Date , Serial_Number , Last_ImpectionDate FROM tableYY

Edit: Damn @plog has faster fingers.

 

[MushroomKing]

Plog is right.
You could make 2 (lets say A and B) queries for your 2 tables.
Then make a new query (C).
Now copy the SQL code from query A and B and put them into the SQL editor of C.

In between those 2 blocks of code, put the word UNION.

If you run your query, it will "merge" A+B.

Hope kinda makes sense.