本文介绍了SQL选择,求和和分组简单问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

SELECT     Product.Name, SUM(Product.Quantity) AS Balance, SUM(Income.IncomeQuantity) AS income, SUM(ProductLog.Quantity) as sold
    FROM         Income INNER JOIN
                          Product ON Income.ProductID = Product.ID INNER JOIN
                          ProductLog ON Product.ID = ProductLog.ProductID GROUP BY Name



此查询无法正常工作.在产品表中,收入为三行,该查询仅返回两行,因为productLog表仅包含两个产品的数据.我如何选择productLog或收入是否不包含当前产品ID返回0

请参阅截图 http://imageshack.us/photo/my-images/12/capturezfs.png/ [ ^ ]



This query does not works correctly. In product table and income is three rows and this query returns only two because productLog table contains data only two products. how i can select if productLog or income does not contains current product id return 0

see screenshot http://imageshack.us/photo/my-images/12/capturezfs.png/[^]

推荐答案


这篇关于SQL选择,求和和分组简单问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-13 17:11