>
>How about posting the query?

Here it is:

SELECT PROPERT3.BORO, PROPERT3.BLOCK, PROPERT3.LOT, PROPERT3.TAXYEAR,;
CERTFILE, certothr, REQUEST,AUDITOR, COMPLETE, CONFREQ1, CORPCOUN, CONFDATE,;
RESULT, RJIFILED, NOTES FROM PROPERT3 LEFT OUTER JOIN CONFSTAT ON ;
PROPERT3.BORO+STR(PROPERT3.BLOCK,6,0)+STR(PROPERT3.LOT,6,0)+;
STR(PROPERT3.TAXYEAR,4,0)= CONFSTAT.BORO+STR(CONFSTAT.BLOCK,6,0);
+STR(CONFSTAT.LOT,6,0)+STR(CONFSTAT.TAXYEAR,4,0) INTO CURSOR TMP_CURS;
WHERE (CERTOTHR = 'Y' OR CERTFILE <> {}) ORDER BY PROPERT3.BORO,;
PROPERT3.BLOCK, PROPERT3.LOT, PROPERT3.TAXYEAR, CONFDATE