so i'm having trouble finding the correct way to join 2 tables together which dont have a 1 to 1 relationship..
so table A will have multiple records, with a single value for each record. so for example a payables invoice header record
table B holds the same reference as table A but there are multiple values for the same reference. so for example the account distributions for a payables record (lets say 3 lines)
when i try to add a column from table B to table A, i only get the first record from table B rather than a replication of 3
the joins dont see to be able to allow this