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