Re: Help with query

From: Rohtash Kapoor (rohtash_nospam_at_sqlmantra.com)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 07:59:33 -0800

UPDATE SO
SET TotalQty =
    (SELECT SUM(OrderQty) FROM SODet
    WHERE (SalesOrder = '12345') AND (Line = '1')
    GROUP BY SalesOrder)
WHERE SalesOrder = '12345' 

---
Rohtash Kapoor
http://www.sqlmantra.com
"Newbie" <noidea@nospam.com> wrote in message
news:ulmBmOrBEHA.1964@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I want to be able to update a field in one table with the sum of a field
> from another table but i don't know how to link the two
>
> Here is what I have so far to get the TotalQty
> *****TOTAL QRY*****
> SELECT     SalesOrder,SUM(OrderQty) AS TotalQty
> FROM         SODet
> WHERE     (SalesOrder = '12345') AND (Line = '1')
> GROUP BY SalesOrder
>
> I then want to use the result of the above to update the SO table where
the
> SO.SalesOrder = SODet.SalesOrder
>
> i.e Result of TOTAL QRY = 30000
> therefore SO.Total = 30000
>
> How can I do this?
> Thanks
>
>

Relevant Pages

  • Re: Help with query
    ... where would the join expression be? ... "Rohtash Kapoor" wrote in message ... > GROUP BY SalesOrder) ... >> Here is what I have so far to get the TotalQty ...
    (microsoft.public.sqlserver.mseq)
  • Help with query
    ... I want to be able to update a field in one table with the sum of a field ... Here is what I have so far to get the TotalQty ... GROUP BY SalesOrder ... i.e Result of TOTAL QRY = 30000 ...
    (microsoft.public.sqlserver.mseq)