NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
'''Accident and Victim'''
<pre>
SELECT DISTINCTaccident_localid FROMaccidentInner Join link ON accident.accident_guid = link.from_guidInner Join victim ON link.to_guid = victim.victim_guidInner Join location AS AccLoc ON accident.location_guid = AccLoc.location_guidInner Join location AS VicLoc ON victim.location_guid = VicLoc.location_guidWHERElink.from_link_type = 'Accident'AND (AccLoc.location_guid <> VicLoc.location_guid)ORDER BY accident_localid
</pre>
'''Hazard and HazRed'''
hazard_localid
</pre>
'''QM and HazRed'''<pre>SELECT DISTINCTqa_localid FROMlinkInner 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 = qa.location_guidWHERElink.from_link_type = 'QA' AND(HazLoc.location_guid <> HazRedLoc.location_guid)ORDER BYqa_localid </pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]
