SELECT a.PartNum, ..., a.QtyPer * c.CurQty as QtyReq, ; b.OnHand - (a.QtyPer * c.CurQty) as NetQty ; FROM crsCNT c, crsParts a LEFT OUTER JOIN crsMaster b ; ON a.PartNum = b.PartNum ; INTO CURSOR crsTemp