SELECT *
  FROM cnt913_tatv020_cris_sales a, cnt911_tatv010_cris_sonbr b
 WHERE b.service_order_nbr = a.service_order_nbr
   AND b.region_cd = a.region_cd
   AND b.division_cd = a.division_cd
   AND (   SUBSTR (a.sub_class_of_service_cd, 1, 3) NOT IN (
                                          SELECT cos_prefix
                                            FROM temp_cnt115_class_of_service
                                           WHERE SUBSTR (subsid_cd, 1, 2) =
                                                                          'MW')
        OR (subtr (b.class_of_service_cd, 1, 3) NOT IN (
                                          SELECT cos_prefix
                                            FROM temp_cnt115_class_of_service
                                           WHERE SUBSTR (subsid_cd, 1, 2) =
                                                                          'MW')
           )
       )