>Related question. After a record has been added to Covr table, there is no corresponding InsCarr record at that point. My SQL is only returning 2 records because
>it's looking at InsCarr matches and that's all it finds. How can I get all three records from Covr regardless of what is in InsCarr?
>

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