总列显示不正确 [英] 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屋！