Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

pervasive v11 pivot or self join

Status
Not open for further replies.

ssmac

MIS
Apr 17, 2012
1
US
Hi,

I have a table like this

kit|part

1 | 21
1 | 22
1 | 23
1 | 24
2 | 30
2 | 31
....

Number of related parts to kit can be from 1 to 30

Would like to return this in one row like below

Part would ideally be in 1 column separated by a value like comma

Data Type is Integer for both kit and part

1 | 21,22,23,24
2 | 30,31


I have tried self joins and have tried group concat but have not been successful

What is best way to accomplish this ?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top