Merging Tables
Hi all,
I know theres a simple way of doing this but I just can't seem to
figure it out. I have two tables.
Part | Owner | Quantity
A | Paul | 2
A | James | 3
A | John | 4
B | Paul | 1
B | Mike | 6
C | Sean | 3
C | Paul | 2
C | John | 4
Part | Origin
A | Nebraska
A | Ohio
B | California
B | Nevada
B | Florida
C | Nebraska
C | Ohio
I want to get these two tables merged to look like
Part | Owner | Qty | Origin
A | Paul | 2 | Nebraska
A | James | 3 | Ohio
A | John | 4
B | Paul | 1 | California
B | Mike | 6 | Nevada
| | | Florida
C | Sean | 3 | Nebraska
C | Paul | 2 | Ohio
C | John | 4
I know theres a simple way to do it but I can't seem to figure it out.
|