View Single Post
  #1 (permalink)  
Old September 21st, 2007, 10:57 AM
mike.chary mike.chary is offline
Registered User
 
Join Date: Jan 2007
Location: eagan, mn, USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Query Problem

My problem is

CREATE TABLE Test
(ID INT,
 lang1 char(3));

INSERT INTO VALUES(1, 'ENG')
INSERT INTO VALUES(1, 'JPN')
INSERT INTO VALUES(1, 'PRB')
INSERT INTO VALUES(2, 'SPC')
INSERT INTO VALUES(2, 'ENG')
INSERT INTO VALUES(3, 'JPN')
INSERT INTO VALUES(3, 'PRB')
INSERT INTO VALUES(3, 'SPC')

I want output liks this

ID Lang1
1 ENG,JPN,PRB
2 SPC,ENG
3 JPN,PRB,SPC

Please help

Thanks in advance
Reply With Quote