Re: More help with query
From: Newbie (noidea_at_nospam.com)
Date: 03/10/04
- Next message: Newbie: "Re: Help with query"
- Previous message: Newbie: "More help with query"
- In reply to: Newbie: "More help with query"
- Next in thread: Newbie: "Re: More help with query"
- Reply: Newbie: "Re: More help with query"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 10 Mar 2004 17:00:57 -0000
Oops forgot the sum(SODet.OrderQty) need to be limited to records with
LineType = '1'
Thanks
"Newbie" <noidea@nospam.com> wrote in message
news:%23R8YLDsBEHA.1380@TK2MSFTNGP10.phx.gbl...
> 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
>
>
- Next message: Newbie: "Re: Help with query"
- Previous message: Newbie: "More help with query"
- In reply to: Newbie: "More help with query"
- Next in thread: Newbie: "Re: More help with query"
- Reply: Newbie: "Re: More help with query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
