Ok check all my code page and some are different. How do I fix them? did not see how in threads

>Take a look at Re: SQL select slow on tables shared with VFP8 Thread #972500 Message #972627
>
>>if vfp3 runs great, same code in vfp9 takes too long.
>>

>>   SELECT a.ssn, last_name, first_name, mid_name, ;
>>   address1, address2, city, state, zip_code, ;
>>   b.end_type, d.cert_desc, ;
>>   iif(!empty(b.fteff_date),b.fteff_date,b.cur_eff) as cur_eff, ;
>>   iif(!empty(b.ftexp_date),b.ftexp_date,b.exp_date) as exp_date, ;
>>   c.subj_num, c.level_code, ;
>>   c.org_eff AS end_eff, c.exp_date AS end_date, b.deficien ;
>>   FROM teacher A, certif B, endorsem C, endtype D ;
>>   WHERE a.ssn = '000000000' ;
>>   and a.ssn = b.ssn ;
>>   and (b.print = .T. or b.printl = .T.) ;
>>   AND b.ssn+b.end_type = c.ssn+c.end_type ;
>>   AND b.end_type = d.end_type ;
>>   INTO CURSOR temp1 ;
>>   order by a.ssn, b.end_type
>>