>>Somehow, I need to get this from the SQL below. In one SQL if possible. RecNo does not work well in JOINs, etc, but I'm thinking if I can make the 1st one select from the 2nd one, it might work. I don't know though; the more I look at it, the more it looks like crap.
>>

>>CarName     Seq     Rec
>>

>>

>>SELECT InsCarr.CarName FROM InsCarr JOIN Covr ON InsCarr.InsCarr=Covr.cvCarr ;
>>WHERE Covr.Pat_No=Patient.PtPn AND CvPS=InsuranceLevel AND ! DELETED() ;
>>ORDER BY 1 INTO CURSOR CarrierList
>>
>>SELECT PADL( Seq_Num, 4, '0' ) AS Seq, RECNO() AS Rec FROM covr WITH (BUFFERING=.T.) ;
>>WHERE Pat_No=Patient.PtPn AND CvPS=InsuranceLevel AND ! DELETED() ;
>>ORDER BY 1 INTO CURSOR SequenceList
>>

>
>Something like this?
>
>

>SELECT InsCarr.CarName, Seq, Rec FROM InsCarr JOIN (SELECT PADL( Seq_Num, 4, '0' ) AS Seq, RECNO() AS Rec 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.