Changes

Missing Local ID

460 bytes added, 09:21, 12 February 2014

no edit summary

accidentinfoversion.accident_localid IS NULL) AND

accidentinfoversion.link_only = '0'

ORDER BY

accident.accident_localid ASC

</pre>

'''Hazard'''

(hazardinfoversion.hazard_localid IS NULL or

hazard.hazard_localid IS NULL )

ORDER BY

hazard.hazard_localid ASC

</pre>

'''Hazard Reduction'''

<pre>

SELECT

hazreducinfoversion.hazreduc_localid,

hazreduc.hazreduc_localid

FROM

hazreducinfoversion

Inner Join hazreduc ON hazreducinfoversion.hazreduc_guid = hazreduc.hazreduc_guid

WHERE

(hazreducinfoversion.hazreduc_localid IS NULL OR

hazreduc.hazreduc_localid IS NULL) AND

hazreducinfoversion.link_only = '0'

ORDER BY

hazreduc.hazreduc_localid ASC

</pre>

[[Category:NoPublic]]

[[Category:SQL Queries]]

• ← Older edit
• Newer edit →

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits