>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
>
No it is NOT legal. And even that query didn't rise an error this is not right at all.
You didn't join both tables crsCNT and crsParts.
The result you got will be: every record in crsCNT will be joined with CURRENT record of the crsParts, is that you want?
I doubt about it.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.