asked on

Group records where linked field is the same (Excel/SQL)

I have two tables Controls & Systems, which are left outer joined (controls - systems).

A control can have multiple systems attached to it. Currently the results come back as :

Control No Control System
01254 aaaaa excel
01254 aaaaa oracle
01252 bbbbb oracle
02543 ccccc
01275 ddddd excel
01275 ddddd outlook
01275 ddddd word
However I want it to come back as:

Control No Control System
01254 aaaaa excel | oracle
01252 bbbbb oracle
02543 ccccc
01275 ddddd excel | outlook | word

When I originally prepared the reports in Crystal it did come back like this. However when I try it now in Excel or Crystal it seperates them out into indvidual rows.

Is there any way of combining the Systems results onto one row? Any help would be appreciated

Navicerts

So Controls is keyed on [Control No] while Systems is keyed on [Control No] AND [System]?

SOLUTION

Navicerts

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION