NoPublic, bureaucrat, administrator
6,632
edits
Changes
Created page with "These queries finds records that do not have links which might not be a data quality issue depending on the business rules in your country. They are added to V6.0 as Saved sea..."
These queries finds records that do not have links which might not be a data quality issue depending on the business rules in your country. They are added to V6.0 as Saved searches with a syntax that works as Saved search <br />
'''Accidents without link to Victim'''
<pre>
SELECT DISTINCT
accident_localid
FROM
accident
WHERE accident.accident_guid NOT IN (
SELECT DISTINCT
accident.accident_guid
FROM
link
Inner Join accident ON accident.accident_guid = link.from_guid
WHERE
link.to_link_type = 'Victim')
ORDER BY
accident_localid
</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]
'''Accidents without link to Victim'''
<pre>
SELECT DISTINCT
accident_localid
FROM
accident
WHERE accident.accident_guid NOT IN (
SELECT DISTINCT
accident.accident_guid
FROM
link
Inner Join accident ON accident.accident_guid = link.from_guid
WHERE
link.to_link_type = 'Victim')
ORDER BY
accident_localid
</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]
