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