>You might want to use tags so you can format this a little better. I tried to look at it, but it was to hard to understand in its present format.
>
>PF


Perry - the tags need to be set off with spaces around the < and > symbols in your text to prevent them from being formatted out and processed as HTML tags. Your text makes much better sense when it reads as:

>You might want to use < pre > and < /pre > (remove the embedded spaces to make them work) HTML tags so you can format this a little better. I tried to look at it, but it was to hard to understand in its present format.



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