Untitled

 avatar
unknown
sql
2 years ago
650 B
5
Indexable
SELECT 1
        FROM equipment_object
       WHERE (((structure_ IS NULL OR structure_ = 'F') AND
             functional_object_seq = equipment_object_seq_) OR
             (structure_ = 'L' AND location_object_seq = equipment_object_seq_) OR
             (structure_ = 'R' AND from_object_seq = equipment_object_seq_) OR
             (structure_ = 'T' AND to_object_seq = equipment_object_seq_) OR
             (structure_ = 'P' AND process_object_seq = equipment_object_seq_) OR
             (structure_ = 'S' AND pipe_object_seq = equipment_object_seq_) OR
             (structure_ = 'E' AND circuit_object_seq = equipment_object_seq_))
Editor is loading...