The issue I am having is the following:
Table1.FieldA is unique where as the Table2.FieldA field is not.
When I run the following:
SELECT Table1.Numbers, Table2.Numbers
FROM Table1, Table2
WHERE Table1.ID = Table2.ID
I get mutiple records like so:
ID Name Numbers
125 John Doe 555, 556, 557
125 John Doe 686, 687
I know this is happening bc there are multiple records in Table2.ID which match the unique record in Table1.ID
My question is, how can I merge the returned results into one row when I have multiple matches.