Printer FriendlyEmail Article Link

What Informix SQL can I use to display all React/Perform circuits that have a specific HECIG (Equipment) code?

Answer

Lists all ckts that contain a specific equipment code:

select circuit_no.circuit_no 
from circuit_no,circuits,segments,elements,tid_info,eqptcodes 
where segments.segments_idx=elements.segments_idx and
segments.circuits_idx=circuits.circuits_idx and circuits.circuits_idx=circuit_no.circuits_idx and
elements.tid_info_idx=tid_info.tid_info_idx and tid_info.eqptcodes_idx=eqptcodes.eqptcodes_idx and
cust_eqptcode={"insert customer equipment code"}
 


Product : Informix