I am trying to multiply the qtyper partnum to crsCNT.CurQty which is the unit demand. In the original Select statement, it has this...

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 crsTemp

How would I be able to join my crsCNT cursor to it that has CurQty that I need to replace the m.lnQty?

Thanks,
Sam