使用递归查询
WITH TEMP AS
(
SELECT * FROM Companyinfo WHERE Compid = '3000'
UNION ALL
SELECT B.* FROM TEMP A INNER JOIN Companyinfo B ON B.Pcompid = A.Compid
)
SELECT B.Compid,CONVERT(VARCHAR(6),B.Paydatc,112) Paymonth,B.Paytype,SUM(B.Amount)Amount
FROM TEMP A
INNER JOIN T_zj_pay B ON A.Compid = B.Compid
GROUP BY B.Compid,CONVERT(VARCHAR(6),B.Paydatc,112),B.Paytype
最后那个注意没看明白具体是啥意思
WITH TEMP AS
(
SELECT * FROM Companyinfo WHERE Compid = '3000'
UNION ALL
SELECT B.* FROM TEMP A INNER JOIN Companyinfo B ON B.Pcompid = A.Compid
)
SELECT B.Compid,CONVERT(VARCHAR(6),B.Paydatc,112) Paymonth,B.Paytype,SUM(B.Amount)Amount
FROM TEMP A
INNER JOIN T_zj_pay B ON A.Compid = B.Compid
GROUP BY B.Compid,CONVERT(VARCHAR(6),B.Paydatc,112),B.Paytype
最后那个注意没看明白具体是啥意思
