Re: More help with query
From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 03/11/04
- Next message: Steve Kass: "Re: Running totals on a select count statement"
- Previous message: zack: "Re: Running totals on a select count statement"
- In reply to: Newbie: "Re: 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: Thu, 11 Mar 2004 09:53:41 +0530
Try:
begin transaction
UPDATE SOQuot
SET TotalQty = (Select sum(OrderQty) FROM SODet
where SOQuot.SalesOrder = SODet.SalesOrder
and SODet.Line = '1')
--check the data and commit/rollback accordingly.
-- Vishal Parkar vgparkar@yahoo.co.in
- Next message: Steve Kass: "Re: Running totals on a select count statement"
- Previous message: zack: "Re: Running totals on a select count statement"
- In reply to: Newbie: "Re: 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 ]
