NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
WHERE accident.location_guid <> victim.location_guid
</pre>
'''Hazard /Land and HazRed/Activity'''
<pre>
SELECT DISTINCThazard_localid hazard.hazard_guid FROMhazardInner Join link ON hazard.hazard_guid = link.from_guidInner Join hazreduc ON link.to_guid = hazreduc.hazreduc_guidInner Join location AS HazLoc ON WHERE hazard.location_guid = HazLoc.location_guidInner Join location AS HazRedLoc ON hazreduc.location_guid = HazRedLoc.location_guidWHERElink.from_link_type = 'Hazard'AND (HazLoc.location_guid <> HazRedLochazreduc.location_guid)ORDER BYhazard_localid
</pre>
'''QM and HazRed/Activty'''
<pre>
SELECT DISTINCTqa_localid qa.qa_guid FROMqa INNER JOIN link ON qa_guid = linkInner Join .from_guid INNER JOIN hazreduc ON link.to_guid = hazreduc.hazreduc_guidInner Join location AS HazLocInner Join location AS HazRedLoc ON hazreduc.location_guid = HazRedLoc.location_guidInner Join qa ON link.from_guid = qa.qa_guid AND HazLoc.location_guid = WHERE qa.location_guidWHERElink.from_link_type = 'QA' AND(HazLoc.location_guid <> HazRedLochazreduc.location_guid)ORDER BYqa_localid
</pre>
