SELECT
A.id,
isnull(B.count, 0) AS count
FROM
表A AS A
LEFT JOIN (
SELECT
Aid,
COUNT (*) count
FROM
表B
GROUP BY
Aid
) C ON C.Aid= A.id
A.id,
isnull(B.count, 0) AS count
FROM
表A AS A
LEFT JOIN (
SELECT
Aid,
COUNT (*) count
FROM
表B
GROUP BY
Aid
) C ON C.Aid= A.id