总列显示不正确 [英] Total column is not correct display
问题描述
我有两个Sql查询,
第一次查询总数正确显示日期搜索时的Column1(日期),Column2(总计)
如果First Query Total是100
第二次查询,当我在查询中添加column2时总计不显示正确
Column1(Date),Column2 (User_Name),第3列(总计)日期搜索
列添加后第二次查询总计为200
我的第一个查询总数是正确的,我想在添加column2(User_Name)之后在第二个查询中获得相同的总数
我尝试了什么: < br $>
'首次查询
SELECT 搜索.dbo.Invoice_Detail.Invoice_date 日期,Sum(Search.dbo.Invoice_Detail.Product_total) 总计
FROM 搜索。 dbo.Invoice_Detail WHERE Invoice_Detail.Invoice_date = ' 2018-04-29'
Group by Invoice_Detail.Invoice_date
< br $>
'第二次查询
SELECT Cast (Search.dbo.Invoice_Detail.Invoice_date as 日期)日期,cast(Search.dbo.Invoice_Master.Login_User_name as NCHAR )User_Name,
Sum(Search.dbo.Invoice_Detail.Product_total)总计
FROM Search.dbo.Invoice_Master INNER JOIN Search.dbo.Invoice_Detail
ON Invoice_Master.Invoice_date = Invoice_Detail.Invoice_date
WHERE Invoice_Detail.Invoice_date = ' 2018-04- 29'
组 Invoice_Detail.Invoice_date,Invoice_Master.Login_User_name
目前你已根据日期栏加入了表格
FROM Search.dbo.Invoice_Master INNER JOIN Search.dbo.Invoice_Detail
ON Invoice_Master。 Invoice_date = Invoice_Detail。 Invoice_date
我猜这不是表之间的实际连接列。相反,可能多个发票可以具有相同的日期。
调查模式并检查Invoice_Detail中的哪个列是Invoice_Master的外键,并在加入表时使用它。 / BLOCKQUOTE>
I have two Sql query,
First query total is correct display Column1(Date), Column2(Total) on date search
if First Query Total is 100
Second query, when i add column2 in query Total not display correct
Column1(Date), Column2(User_Name),Column3(Total) on date search
Second Query Total is 200 after column add
My first Query total is correct, i want same total in second query after add column2(User_Name)
What I have tried:
'First Query
SELECT Search.dbo.Invoice_Detail.Invoice_date"Date", Sum(Search.dbo.Invoice_Detail.Product_total)"Total" FROM Search.dbo.Invoice_Detail WHERE Invoice_Detail.Invoice_date = '2018-04-29' Group by Invoice_Detail.Invoice_date
'Second Query
SELECT Cast(Search.dbo.Invoice_Detail.Invoice_date as Date) Date, cast(Search.dbo.Invoice_Master.Login_User_name as NCHAR) User_Name, Sum(Search.dbo.Invoice_Detail.Product_total) Total FROM Search.dbo.Invoice_Master INNER JOIN Search.dbo.Invoice_Detail ON Invoice_Master.Invoice_date=Invoice_Detail.Invoice_date WHERE Invoice_Detail.Invoice_date = '2018-04-29' Group by Invoice_Detail.Invoice_date,Invoice_Master.Login_User_name解决方案At the moment you have joined the tables based on a date column
FROM Search.dbo.Invoice_Master INNER JOIN Search.dbo.Invoice_Detail ON Invoice_Master.Invoice_date=Invoice_Detail.Invoice_date
I would guess that this is not the actual joining column between the tables. Instead probably multiple invoices can have the same date.
Investigate the schema and check what column in Invoice_Detail is the foreign key to Invoice_Master and use that when joining the tables.
这篇关于总列显示不正确的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!