这个SQL怎么弄!!!!
select cast(amountsum as varchar(10))+'×'+boxsize+boxtype as BoxInfo,conid
from (SELECT SUM(Amount) AS amountsum, BoxSize, BoxType, ConID
FROM T_PlanBox
GROUP BY ConID, BoxSize, BoxType) mm
查出:
boxinfo conid
23×20'GP 12312321
12×20'OT 12312321
想要看到的信息是:
boxallinfo conid
23×20'GP/12×20'OT 12312321
该怎么实现亚!