Forum Discussion
Solved
Merging two tables without duplicates based on certain data
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. Not...
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
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