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

(at least under VFP9) recno() works perfectly well even with joins but it is deleted() that you shouldn't use with joined selects. Better do not use both for easy controlling of SQL. You didn't say what is your intention (or yuou did but I didn't get) so I don't have an idea what the SQL might look like. From the two SQLs I see I can't derive anything.
Cetin