Transformating Query Output (1 Viewer)

mab9

Registered User.
Local time
Today, 12:20
Joined
Oct 25, 2006
Messages
63
I have a simple table of cross references, built like:

ItemNo1 ItemNo2
12345 ABC1
32346 BBC2
53456 ZZZ1
53456 ZZZ2

I'm trying to figure out a way to query against this table to transform the output into the figure below due to the 1-many relationship between the records.

ItemNo1 ItemNo2
12345 ABC1
32346 BBC2
53456 ZZZ1,ZZZ2

Any ideas? I'm not quite sure where to start. Thanks!
 

mab9

Registered User.
Local time
Today, 12:20
Joined
Oct 25, 2006
Messages
63
That's perfect, thanks!
 

Users who are viewing this thread

Top Bottom