create or replace view combined_live_arch_bsms_v1
( log_time, bag_tag, flight_id, bsm_log ) as
( select l.log_time, d.bag_tag, 
         l.flight_id, l.bsm_log from bsm_log l, bsm_data d where                     l.bsm_id=d.bsm_id UNION ALL 
  select l.log_time, d.bag_tag, 
         l.flight_id, l.bsm_log from arch.bsm_log l, arch.bsm_data d where  l.bsm_id=d.bsm_id );
