>>

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

>
>I had to just add cvCarr to the inner SQL, but that worked. I don't fully understand it, but it worked. Thanks!

Finally! :)

No problem, glad to help.