Unknown device Accident

From IMSMA Wiki
Revision as of 16:53, 22 May 2014 by Alnaucler (talk | contribs) (Created page with "If this query gives you any result set then the data needs to be further analysed <pre> SELECT accident.accident_localid, imsmaenum.enumvalue FROM accident Inner Join imsmaenu...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

If this query gives you any result set then the data needs to be further analysed

SELECT
accident.accident_localid,
imsmaenum.enumvalue
FROM
accident
Inner Join imsmaenum ON accident.unknowndevice_guid = imsmaenum.imsmaenum_guid
WHERE
accident.unknowndevice_guid IS NOT NULL