Posted on 2011-02-28
I have two tables; a and b. The following is the structure for said tables:
The two tables have a 1 to many relationship; therefore for every one record in table a, there could be many records in table b that are related.
Here is the problem....
I am running the following SQL and getting the following results:
SELECT a.a_id, b.b_id FROM a INNER JOIN b ON a.a_id = b.a_id;
Instead of getting a multiple returned rows for each record in table b, is there a way to get them on a single line so the returned record sets look like this: