Changes

SQL Saved search No links

2 bytes added, 15:58, 20 May 2014

no edit summary

'''Accidents without link to Victim'''

<pre>

SELECT DISTINCTaccident_localid accident.accident_guid FROMaccident WHERE accident.accident_guid NOT IN (SELECT DISTINCTaccident.accident_guidFROM accident INNER JOIN linkInner Join accident ON link.from_guid = accident.accident_guid = link.from_guidWHEREINNER JOIN victim ON link.to_link_type to_guid = 'Victim'victim.victim_guid )ORDER BYaccident_localid

</pre>

'''Victims without link to Accident'''

• ← Older edit
• Newer edit →

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits