NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
'''Accident and Victim'''
<pre>
SELECT DISTINCTaccident_localid accident.accident_guid FROMaccidentInner Join link ON accident.accident_guid = link.from_guidInner Join victim ON link.to_guid = victim.victim_guidInner Join location AS AccLoc ON WHERE 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 <> VicLocvictim.location_guid)ORDER BY accident_localid
</pre>
'''Hazard and HazRed'''
