Hello Experts,
Let's say I have 4 lines in a child table that point to a line in a parent table. Right now I'm INNER JOINing them on the parent table's primary key, and it's giving me 4 records that look like this...
Key | child1val
Key | child2val
Key | child3val
Key | child4val
What I'd like to do is merge these all into 1 row that looks like this...
Key | child1val | child2val | child3val | child4val
Any suggestions?
Let's say I have 4 lines in a child table that point to a line in a parent table. Right now I'm INNER JOINing them on the parent table's primary key, and it's giving me 4 records that look like this...
Key | child1val
Key | child2val
Key | child3val
Key | child4val
What I'd like to do is merge these all into 1 row that looks like this...
Key | child1val | child2val | child3val | child4val
Any suggestions?
Comment