Advertisement
janel_a_carpenter

1126437, Step 1 Educ_History

Mar 7th, 2017
962
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 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
  2. s.account_id = e.account_id
  3. AND (e.chapter2  IN(234225,38354)
  4. OR school_id IN(38354))
  5. AND flagstring NOT LIKE '%Z1%'
  6. AND flagstring NOT LIKE '%Z5%'
  7. AND combined_flag = 'N'
Advertisement
RAW Paste Data Copied
Advertisement