mysql - 带有子查询的两个表的总和

Question

我有疑问

SELECT c.user_id, 
   (SELECT COUNT(*) FROM jos_findme_bestof b WHERE b.user_id = c.user_id) as bCount,
   (SELECT COUNT(*) FROM jos_findme_pair   p WHERE p.user_id = c.user_id) as pCount,
   (SELECT COUNT(*) FROM jos_findme_style  s WHERE s.user_id = c.user_id) as sCount,

FROM   jos_findme c

如何使用 bCount + pCount + sCount 创建列？

谢谢

Answer 1

如果您想在查询中添加该列:

   SELECT *,(bCount+pCount+sCount) as sumCount FROM(
    SELECT c.user_id, 
       (SELECT COUNT(*) FROM jos_findme_bestof b WHERE b.user_id = c.user_id) as bCount,
       (SELECT COUNT(*) FROM jos_findme_pair   p WHERE p.user_id = c.user_id) as pCount,
       (SELECT COUNT(*) FROM jos_findme_style  s WHERE s.user_id = c.user_id) as sCount,

    FROM   jos_findme c)