Advertisement
janel_a_carpenter

1126437, Step 2 Pass-through

Mar 7th, 2017
3,057
0
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.flagstring, s.address3, s.address2, s.city, s.state, s.zip, s.last_fiscal_year, s.last_amount, s.total_gift_amount, s.primary_phone, s.primary_email, e.amount, e.bdate, e.CHAPTER, e.chapter2 FROM jcl.v_account_summary s, jcl.v_donation e WHERE
  2. s.account_id = e.account_id AND (e.chapter2  IN (234225,38354) OR e.chapter IN (38954))
  3. AND flagstring NOT LIKE '%Z1%'
  4. AND flagstring NOT LIKE '%Z5%'
  5. AND combined_flag = 'N'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement