22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT ISNULL(A.ID,B.ID),A.AMOUNT_A,B.AMOUNT_B
FROM
(SELECT ID,COUNT(*) AS AMOUNT_A
FROM MEMBER C
JOIN A ON C.关联字段=A.关联字段
GROUP BY ID) AS A
FULL JOIN
(SELECT ID,COUNT(*) AS AMOUNT_B
FROM MEMBER C
JOIN B ON C.关联字段=B.关联字段
GROUP BY ID) AS B ON A.ID=B.ID