select ?
select t1.name,t1.id,t2.name as listtwo,t2.id as idtwo form
( select name ,id ,time,joy form table1
) t1,
( select name ,id ,time,joy form table1
) t2
where t1.name=t2.name and
t1.id=t2.id
问题是T1，T2里的数据是有重复的。
nameidlisttwoidtwo
2512512
2512512
2412412
24121010
怎样写能把第一，二项，合成：
25121012
[解决办法]
select name,id,sum(listtwo) listtwo, idtwo
from
(select t1.name,t1.id,t2.name as listtwo,t2.id as idtwo form
( select name ,id ,time,joy form table1
) t1,
( select name ,id ,time,joy form table1
) t2
where t1.name=t2.name and
t1.id=t2.id
) t
group by t.name,id,listtwo,idtwo;
