1126437, Step 1 Educ_History

SELECT s.account_id, s.first_name, s.last_name, s.alt_first_name, s.alt_last_name, s.company, s.address3, s.address2, s.city, s.state, s.zip, s.primary_phone, s.primary_email, s.last_amount, s.last_fiscal_year, s.total_gift_amount, s.flagstring, e.* FROM jcl.v_account_summary s, jcl.v_education e WHERE
s.account_id = e.account_id
AND (e.chapter2  IN(234225,38354)
OR school_id IN(38354))
AND flagstring NOT LIKE '%Z1%'
AND flagstring NOT LIKE '%Z5%'
AND combined_flag = 'N'