NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
accidentinfoversion.accident_localid IS NULL) AND
accidentinfoversion.link_only = '0'
</pre>
'''Hazard'''
<pre>
SELECT
hazardinfoversion.hazard_localid,
hazard.hazard_localid,
hazardinfoversion.dataentrydate,
hazardinfoversion.dataenterer
FROM
hazardinfoversion
Inner Join hazard ON hazardinfoversion.hazard_guid = hazard.hazard_guid
WHERE
hazardinfoversion.link_only = '0' AND
(hazardinfoversion.hazard_localid IS NULL or
hazard.hazard_localid IS NULL )
</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]
