Changes

Missing Local ID

307 bytes added, 09:53, 12 February 2014

no edit summary

ORDER BY

qa.qa_localid ASC

</pre>

'''Victim'''

<pre>

SELECT

victiminfoversion.victim_localid,

victim.victim_localid

FROM

victiminfoversion

Inner Join victim ON victiminfoversion.victim_guid = victim.victim_guid

WHERE

(victiminfoversion.victim_localid IS NULL OR

victim.victim_localid IS NULL) AND

victiminfoversion.link_only = '0'

</pre>

[[Category:NoPublic]]

[[Category:SQL Queries]]

• ← Older edit
• Newer edit →

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits