将 2 个表的总和插入一行 [英] Inserting Sum of 2 tables into a row

问题描述

我想将根据其他 2 个表计算的总和存储在总计"表的一行中.

我想为每个表使用一列.

我尝试了以下方法:

<前>INSERT INTO 总计(日期，FirstTableSum,第二表总和)选择'2010/01/31',SUM(t.Data1),SUM( v.Data2 )从FirstTable 作为 t，第二表作为 v在哪里t.Date = '2010/01/31'AND v.Date = '2010/01/31'

如果我进行查询以检查 2 个不同表的总和，我有不同的值.

<前>SELECT SUM(Data1) FROM FirstTable WHERE Date='2010/01/31'/*结果与FirstTableSum不同:为什么?*/SELECT SUM(Data2) FROM SecondTable WHERE Date='2010/01/31'/*结果与SecondTableSum为什么不同?*/

我做错了什么?

谢谢

解决方案

试试这个

SELECT(SELECT SUM(Data1) FROM FirstTable WHERE Date=@date) FirstTableSum,(SELECT SUM(Data2) FROM SecondTable WHERE Date=@date) SecondTableSum

I would like to store in a row of a 'Totals' table the sum calculated from 2 other tables.

I want to use a column for each table.

I tried the following:

INSERT INTO Totals
(
    Date,
    FirstTableSum,
    SecondTableSum
)

SELECT 
    '2010/01/31',
    SUM( t.Data1 ),
    SUM( v.Data2 )
FROM
    FirstTable as t,
    SecondTable as v
WHERE 
    t.Date = '2010/01/31'
AND v.Date = '2010/01/31'

If I make a query to check the sums of the 2 distinct tables I have different values.

SELECT SUM(Data1) FROM FirstTable WHERE Date='2010/01/31'
/*The result is different from FirstTableSum: Why?*/

SELECT SUM(Data2) FROM SecondTable WHERE Date='2010/01/31'
/*The result is different from SecondTableSum Why?*/

What am I doing wrong?

Thanks

解决方案

try this

SELECT 
 (SELECT SUM(Data1) FROM FirstTable WHERE Date=@date) FirstTableSum,
 (SELECT SUM(Data2) FROM SecondTable WHERE Date=@date) SecondTableSum

这篇关于将 2 个表的总和插入一行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！