SELECT a.PartNum, ..., a.QtyPer * m.lnQty as QtyReq, ; b.OnHand - (a.QtyPer * m.lnQty) as NetQty ; FROM crsParts a LEFT OUTER JOIN crsMaster b ; ON a.PartNum = b.PartNum ; INTO CURSOR crsTempHow would I be able to join my crsCNT cursor to it that has CurQty that I need to replace the m.lnQty?