21,886
社区成员
发帖
与我相关
我的任务
分享
SELECT A.xiangce_id, A.xiangce_title, B.count( * ) AS num
FROM A
outer JOIN B ON B.xiangce_id = A.xiangce_id
SELECT A.xiangce_id, A.xiangce_title, count( * ) AS num
FROM A
LEFT JOIN B ON B.xiangce_id = A.xiangce_id
GROUP BY A.xiangce_id
LIMIT 0 , 30