NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
hazard_localid
</pre>
'''HazRed without link''' If the country records Hazards as outcome of surveys or Clearance/Completion are done on Hazards then there should be links<pre>SELECT DISTINCThazreduc_localid FROMlinkRight Join hazreduc ON link.from_guid = hazreduc.hazreduc_guidWHERElink.from_guid IS NULLORDER BYhazreduc_localid </pre>'''QM without link''' QMs really should have links to other objects<pre>SELECT DISTINCTqa_localid FROMqaLeft Join link ON qa.qa_guid = link.from_guidWHERElink.from_guid IS NULLORDER BYqa_localid </pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]