NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
WHERE
hazardinfoversion.link_only = '0' AND
(hazardinfoversion.hazard_localid IS NULL orOR
hazard.hazard_localid IS NULL )
ORDER BY
ORDER BY
hazreduc.hazreduc_localid ASC
</pre>
'''Location'''
<pre>
SELECT
locationinfoversion.location_localid,
location.location_localid
FROM
locationinfoversion
Inner Join location ON locationinfoversion.location_guid = location.location_guid
WHERE
(locationinfoversion.location_localid IS NULL OR
location.location_localid IS NULL) AND
locationinfoversion.link_only = '0'
ORDER BY
location.location_localid ASC
</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]
