Hi Naomi,

I just did it this way. Is this legal? I just put crsCNT before my join. Thanks, Sam

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