hazreduc.hazreduc_localid
</pre>
'''Open Hazards with links to HazRed or QM'''<pre>SELECT DISTINCT hazard_localidFROM hazard Inner Join imsmaenum ON hazard.status_guid = imsmaenum.imsmaenum_guid Inner Join link ON hazard.hazard_guid = link.from_guid WHERE imsmaenum.enumvalue = 'Active' AND (link.to_link_type = 'HAZARD_REDUCTION' OR link.to_link_type = 'QA' )ORDER BYhazard_localid</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]