Merging two tables without duplicates based on certain data

[shamilka]

I need to join two tables (add the Purchose order column to the table 1) by matching part number and serial number and copy the column with the corresponding purchase order number in table 2.

Note: The column names of the part number and the serial number is different in two tables. 

Table 1

Part number (PN)	Serial Number (SN)	Lot no	Quantity
A	X	A110	1
A	Y	A111	2
A	Z	A112	2
B	J	A113	1
B	K	A114	1
B	H	A115	1

Table 2

Part number	Serial Number	Purchase Order
A	X	1001
A	Y	1002
A	Z	1003
B	J	1004
B	K	1005
B	H	1006

Desired Output:

Part number	Serial Number	Lot no	Quantity	Purchase Order
A	X	A110	1	1001
A	Y	A111	2	1002
A	Z	A112	2	1003
B	J	A113	1	1004
B	K	A114	1	1005
B	H	A115	1	1006

Thank you

[m_dekorte · Accepted solution]

Hi @shamilka,

You can use the Merge Queries option from the ribon. In the dialog that appears hold down the CTRL key as you select the matching column pairs in both tables. Note that there is a small idenification number visible this needs to correstpond for each pair that belongs together (see blue arrow).

I hope this is helpful