Total column is not correct display

See more:

SQL

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