gistfile1.txt

 create temp table event_shp
 as (
 select cust_key,
 case when delivery_channel <> 'JOIN' and
           product_type = 'General' and
           sale_dt in
           (select event_dt
           from user_tbls.events
           where anniversary_public_event=1 ) then 1
      else 0
      end as Anniversary_Public,
 case when delivery_channel <> 'JOIN' and
           product_type = 'General' and
           sale_dt in
           (select event_dt
           from user_tbls.events
           where anniversary_early_access=1) then 1
      else 0
      end as Anniversary_EA,
 from user_tbls.transitory
 );

select cust_key,
 case when delivery_channel <> 'JOIN' and
           product_type = 'General' and
            anniversary_public_event=1 ) then 1
      else 0
      end as Anniversary_Public,
 case when delivery_channel <> 'JOIN' and
           product_type = 'General' and
            anniversary_early_access=1) then 1
      else 0
      end as Anniversary_EA,
 from user_tbls.transitory left join user_tbls.events on sale_dt = event_dt