Issue in summing the value using sql query

Question

In the below query I have 2 tables locationproductmap and productsourceproductmap. My aim is to multiply the quantifier from the productsourceproductmap table with CurrentUnitPrice from the locationproductmap table, and then sum it. But my actual result is displaying incorrect result.

Please help me to do this.

Actual result is 45.

productsourceproductmap

Productid  | Quantifier| locationId
-----------------------------------
1402              1            1
1403              1            1
1404              1            1

locationproductmap

ProductId    | Locationid |CurrentUnit Price
--------------------------------------------
1402              1            5
1403              1            5
1404              1            5

Query

(Select  
     SUM(LPM.CurrentUnitPrice * PSPM.Quatifier) 
 From 
     LocationProductMap LPM 
 LEFT OUTER JOIN
     ProductSourceProductMap PSPM ON PSPM.ProductID IN (1402, 1404, 1403)  
 WHERE 
     LPM.ProductID IN (1402, 1404, 1403) 
     AND LPM.LocationID = 1
)

juergen d · Accepted Answer · 2014-11-06 10:13:27Z

2

Select  SUM(LPM.CurrentUnitPrice * PSPM.Quatifier) 
From LocationProductMap LPM 
LEFT Join ProductSourceProductMap PSPM ON PSPM.ProductID = LPM.ProductID 
WHERE LPM.LocationID = 1
AND LPM.ProductID IN (1402,1404,1403)

When joining specify the link of the tables in the ON condition. If you want to filter the data then add that to your where clause.

answered Nov 6, 2014 at 10:13

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Kamil Gosciminski Over a year ago

ProductID IN (1402,1404,1403)

juergen d Over a year ago

Can you be more specific?

Collectives™ on Stack Overflow

Issue in summing the value using sql query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related