E-learn Weblog of Willem van Valkenburg

select
  to_char(timestamp,'YYYYMMDD'),
  count(distinct(user_pk1))
from
  (
  select user_pk1, timestamp from bb_bb60_stats.activity_accumulator
  union
  select user_pk1, timestamp from bb_bb60.activity_accumulator
  )
where
  timestamp between to_date('01092004','DDMMYYYY') and to_date('01112004','DDMMYYYY')  
group by
  to_char(timestamp,'YYYYMMDD')
order by
  1