Subversion Repositories computer_asset_manager_v1

update
   maintenance_schedule
set
   login_id = 6
where
   removed_date is null
   and device_id in (
      select
         device_id
      from
         device
      where
         removed_date is null
         and site_id in ( 16,38 )
         and device_type_id in (
            select
               device_type_id
            from
               device_type
            where
               show_as_system = 'Y'
            )
      )