I have two tables. Tbl1 starts by having only OrderNo for data. Tbl2 has multiple occurences of the same order and owner. I want to add each owner into tbl1. An example is below.
tbl1
OrderNo Owner1 Tractor Owner2
123
456
tbl2
OrderNo Owner Tractor
123 9 7
123 9 7
456 11 12
123 8 6
RESULT WANTED:
tbl1
OrderNo Owner1 Tractor Owner2
123 9 7 8
456 11 12 <null>
tbl1
OrderNo Owner1 Tractor Owner2
123
456
tbl2
OrderNo Owner Tractor
123 9 7
123 9 7
456 11 12
123 8 6
RESULT WANTED:
tbl1
OrderNo Owner1 Tractor Owner2
123 9 7 8
456 11 12 <null>