首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >MySQL select语句中的SUM正在递增

问MySQL select语句中的SUM正在递增
EN

Stack Overflow用户
提问于 2017-08-02 21:54:26
回答 1查看 27关注 0票数 0

我有这样一个SQL:

代码语言:javascript
复制
SELECT                      
SUM(er.total)    
AS total
FROM    
campaigns AS cmp    
JOIN versions AS cv ON (cv.campaign_id = cmp.id)
JOIN creatives AS cr ON (cr.version_id = cv.id)
JOIN records AS er ON (er.creative_id = cr.id)
WHERE    
cmp.business_id IN (-1,'39909') AND
cv.campaign_id IN (-1,65288) AND
er.type IN (5,6,1) AND    
er.date BETWEEN '2017-06-11' AND '2017-06-11'    
GROUP BY version_id, er.date

我需要在where子句中添加一个新的条件,为此需要添加新的连接,如下所示-

代码语言:javascript
复制
    SELECT                      
    SUM(er.total)    
    AS total
    FROM    
    campaigns AS cmp
    JOIN products as p ON (p.campaign_id = cmp.id)
    JOIN versions AS cv ON (cv.campaign_id = cmp.id)
    JOIN creatives AS cr ON (cr.version_id = cv.id)
    JOIN records AS er ON (er.creative_id = cr.id)
    WHERE    
    cmp.business_id IN (-1,'39909') AND
    cv.campaign_id IN (-1,65288) AND
    er.type IN (5,6,1) AND    
    er.date BETWEEN '2017-06-11' AND '2017-06-11' AND
    p.product_id IN(1,2)
    GROUP BY version_id, er.date

但是,在这里,SUM(er.total)的值被改变,它被递增。我试着添加了左/右/内连接。但结果是一样的。如何在不增加总数的情况下为该表添加连接?

EN

回答 1

Stack Overflow用户

发布于 2017-08-02 22:09:38

代码语言:javascript
复制
SELECT                      
    SUM(er.total)    
    AS total
    FROM    
    campaigns AS cmp
    JOIN products as p ON (p.campaign_id = cmp.id and p.product_id IN(1,2))
    JOIN versions AS cv ON (cv.campaign_id = cmp.id)
    JOIN creatives AS cr ON (cr.version_id = cv.id)
    JOIN records AS er ON (er.creative_id = cr.id)
    WHERE    
    cmp.business_id IN (-1,'39909') AND
    cv.campaign_id IN (-1,65288) AND
    er.type IN (5,6,1) AND    
    er.date BETWEEN '2017-06-11' AND '2017-06-11' AND

    GROUP BY version_id, er.date

尝试上面的查询。

在这里,我从WHERE子句改为ON条件子句进行了更改。

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/45462902

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档