Below is the SELECT Statement, I open and set the order on the two tables just before i execute the select

SELECT a.provid,a.provname, a.provad1, a.provad2, a.prov_city, a.prov_state,a.prov_zip,;
a.npi, a.membid,a.membname, a.mem_ad1, a.mem_ad2, a.mem_city, a.mem_st, a.mem_zip,;
a.mem_dob,a.diag1, a.diag2,a.diag3,a.diag4, a.PLACESVC, a.NBRUNITS, a.refprov_nm,;
a.prov_taxid, a.e_fname,;
b.begdt,b.enddt,b.svc_code,b.MODIF,b.qty, b.anthtime,b.billed, b.DIAGREF;
FROM clmhderr a,clmdterr b;
WHERE a.seq_no = b.seq_no AND SUBSTR(a.seq_no,1,8) = mmyy AND SUBSTR(a.error2,1,1) = 'E';
INTO CURSOR c_tmp

REPO FORM clmhderr_emp TO PRINT PROMPT