2 Replies Latest reply: Nov 5, 2012 4:54 AM by oracle-911 RSS

    How to combine this query so that i can display the ouput together

    968550
      I have no idea how to combine this query together.Someone please help.I want the ouput to display oni 1 result combining all together.

      select facility, route, operation, script_id
      from F_ROUTEOPER
      where facility = 'A01' and operation in ('6910','7976') AND src_erase_date is null
      and (script_id not in ('PHQ-LOTCHKRV','PHQ-LOTCHK') or script_id is null)
      AND (route NOT LIKE '9EL%' AND route NOT LIKE '9TB%'AND route NOT LIKE 'BLB%' AND route NOT LIKE 'BWR%' AND route NOT LIKE 'CRL%')

      select facility, route, operation, script_id
      from F_ROUTEOPER
      where facility = 'A01' and operation in ('6912','7976') AND src_erase_date is null
      and (script_id not in ('PHQ-LOTCHKRV','PHQ-LOTCHK') or script_id is null)
      AND (route NOT LIKE '9EL%' AND route NOT LIKE '9TB%'AND route NOT LIKE 'BLB%' AND route NOT LIKE 'BWR%' AND route NOT LIKE 'CRL%')

      select facility, route, operation, script_id
      from F_ROUTEOPER
      where facility = 'A01' and operation in ('7344','7976') AND src_erase_date is null
      and (script_id not in ('PHQ-LOTCHKRV','PHQ-LOTCHK') or script_id is null)
      AND (route NOT LIKE '9EL%' AND route NOT LIKE '9TB%'AND route NOT LIKE 'BLB%' AND route NOT LIKE 'BWR%' AND route NOT LIKE 'CRL%')

      select facility, route, operation, script_id
      from F_ROUTEOPER
      where facility = 'A01' and operation in ('8344','7976') AND src_erase_date is null
      and (script_id not in ('PHQ-LOTCHKRV','PHQ-LOTCHK') or script_id is null)
      AND (route NOT LIKE '9EL%' AND route NOT LIKE '9TB%'AND route NOT LIKE 'BLB%' AND route NOT LIKE 'BWR%' AND route NOT LIKE 'CRL%')

      Edited by: 965547 on Nov 5, 2012 12:55 AM