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

Can you please tell what exactly do you want? Do you need to add sequence number to the result? If yes, it's easy using derived tables.

What is the goal exactly?