More help with query

From: Newbie (noidea_at_nospam.com)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 16:57:36 -0000

Variation on prev post . . .

I have 3 tables

SO
SODet, and
SOQuot

SO is linked to SODet by SalesOrder
SO is linked to SOQuot by Quote

I want to update SOQuot.TotalQty with the result of Sum(SODet.OrderQty)

What would the syntax be for this?

Thanks

Relevant Pages

  • Re: More help with query
    ... LineType = '1' ... "Newbie" wrote in message ... > SO is linked to SODet by SalesOrder ... > SO is linked to SOQuot by Quote ...
    (microsoft.public.sqlserver.mseq)
  • Re: More help with query
    ... I have the following which works ok but I don't want to have to put a quote ... UPDATE SOQuot ... SET TotalQty = FROM SODet ...
    (microsoft.public.sqlserver.mseq)