>SELECT Seq,CarName,Rec ; > FROM InsCarr ; > JOIN (SELECT PADL(Seq_Num,4,'0') AS Seq,RECNO() AS Rec,cvCarr ; > FROM covr WITH (BUFFERING=.T.) ; > WHERE Pat_No=Patient.PtPn AND CvPS=THISFORMInsuranceLevel AND ! DELETED() ) Covr ; > ON InsCarr=cvCarr ; > ORDER BY 1 ; > INTO CURSOR SequenceList >Looks like you need a right join from InsCarr to this derived table. Or switch the order and make derived first, then InsCarr and use a LEFT JOIN. For some unknown reason I prefer left joins to right joins though they should operate the same.