>SELECT aa.PartNum, ..., aa.QtyPer * cc.CurQty as QtyReq, ; >bb.OnHand - (aa.QtyPer * cc.CurQty) as NetQty ; >FROM crsCNT cc, crsParts aa LEFT OUTER JOIN crsMaster bb ; >ON aa.PartNum = bb.PartNum ; >INTO CURSOR crsTemp >If crsCNT has just one record, then it's fine. Otherwise you're creating a cartesian product.