You could sum the prices:

select @UnitPrice=SUM(od.UnitPrice) 
from OrderDtl OD 
left outer join ShipDtl SD on od.OrderNum = sd.OrderNum and od.Company = sd.Company 
where od.PartNum = 'DEL' and sd.PartNum = 'DEL' and sd.PackNum = @strPackNum

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top