>>Something like this?
>>
>>
>>SELECT InsCarr.CarName, Seq, Rec FROM InsCarr JOIN (SELECT PADL( Seq_Num, 4, '0' ) AS Seq, RECNO() AS Rec, cvCarr FROM covr WITH (BUFFERING=.T.) ;
>>WHERE Pat_No=Patient.PtPn AND CvPS=InsuranceLevel AND ! DELETED() ) ;
>>Covr ON InsCarr.InsCarr=Covr.cvCarr ;
>>ORDER BY 1 INTO CURSOR CarrierList
>
>It gives an error that "SQL column cvCarr is not found." but I know that Covr.cvCarr exists in that table. My first SQL works fine with that column.
You need to include this field in the inner select (derived table), so it would be visible outside.
If it's not broken, fix it until it is.
My Blog