php - 来自多个表的多个总和

Question

我一直在尝试将每个表中的总数加在一起。我使用过在线查询生成器，但我认为它不正确。

"SELECT SUM(total) mailTotal,
         SUM(total) extraTotal,
         SUM(total) fbaTotal, 
         SUM(total) gdnTotal,
         SUM(total) ppcTotal,
         SUM(total) smTotal, 
         SUM(total) webTotal
FROM admail,
     extra_charges,
     facebook_adds,
     gdn,
     ppc,
     social_media,
     web
WHERE client = 1"

Answer 1

您应该需要像下面这样尝试:

SELECT SUM(ad.total)  as mailTotal,
       SUM(ex.total)  as extraTotal,
       SUM(fa.total)  as fbaTotal,
       SUM(gdn.total) as gdnTotal,
       SUM(ppc.total) as ppcTotal,
       SUM(sm.total)  as smTotal,
       SUM(w.total)   as webTotal
FROM   admail ad,
       extra_charges ex,
       facebook_adds fa,
       gdn gdn,
       ppc ppc,
       social_media sm,
       web w
WHERE  ad.client = 1 

这肯定适合你:)