2.
select A.BNUM, B.BM, A.BDATE from 表B as A,
(select sum(BMONEY) as BM, BMONEY, min(BID) as BID
from 表B group by BMONEY) as B
where A.BID = B.BID
and A.BMONEY = B.BMONEY
select A.BNUM, B.BM, A.BDATE from 表B as A,
(select sum(BMONEY) as BM, BMONEY, min(BID) as BID
from 表B group by BMONEY) as B
where A.BID = B.BID
and A.BMONEY = B.BMONEY
create function aaa @ANUM char(1)
return nvarchar(4000)
as
declalre @a nvarchar(4000)
set @a = ''
select @a = @a + ANAME from 表A where ANUM= @ANUM
return @a
goselect ANUM,min(dbo.aaa(anum)) from 表A
GROUP BY ANUM
把T1换成你的表A就可以select a.ANUM,case when a.ANAME<>b.ANAME then a.ANAME+b.ANAME end
from t1 a cross join t1 b where a.ANUM=b.ANUM and a.AID<b.AID不知道合不合你的意啊