>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
>

If crsCNT has just one record, then it's fine. Otherwise you're creating a cartesian product.