create table temptest (lid varchar(10), dat varchar(20))
insert into temptest (lid,dat) values ('11','first') insert into temptest (lid,dat) values ('11','second') insert into temptest (lid,dat) values ('11','third')
insert into temptest (lid,dat) values ('12','box') insert into temptest (lid,dat) values ('12','circle') insert into temptest (lid,dat) values ('12','trap')
insert into temptest (lid,dat) values ('14','star') insert into temptest (lid,dat) values ('14','planet')
--I want the results to be lid, dat1, dat2, dat3 11,first,second,third 12, box, circle, trap 14, star, planet, <blank>
|