{{Note | All ID are important to be filled in. ''Form ID'' is important for the DEF's Reconcilation tab and I recommend that to update ''Form ID'' after you have have checked the items' ID.
SELECT
fieldreport.fieldreport_localid,
fieldreport.dateofreport AS `"Date of Information`",fieldreport.reportreceiveddate AS `"Data Entry Date`",fieldreport.reportcompleteddate AS `"Submitted Date`",fieldreport.reportverifieddate AS `"Approved Date`",fieldreport.dataenterer AS `"Data enterer`",fieldreport.verifiedby AS `"Approved by`",
imsmaenum.enumvalue,
fieldreportdesc.fieldreportname
fieldreport.fieldreport_localid,
imsmaenum.enumvalue,
fieldreport.dateofreport AS `"Date of Information`",fieldreport.reportreceiveddate AS `"Data Entry Date`",fieldreport.reportcompleteddate AS `"Submitted Date`",fieldreport.reportverifieddate AS `"Approved Date`",fieldreport.dataenterer AS `"Data enterer`",fieldreport.verifiedby AS `"Approved by`",
accidentinfoversion.accident_localid
FROM
fieldreport.fieldreport_localid,
imsmaenum.enumvalue,
fieldreport.dateofreport AS `"Date of Information`",fieldreport.reportreceiveddate AS `"Data Entry Date`",fieldreport.reportcompleteddate AS `"Submitted Date`",fieldreport.reportverifieddate AS `"Approved Date`",fieldreport.dataenterer AS `"Data enterer`",fieldreport.verifiedby AS `"Approved by`",
hazardinfoversion.hazard_localid
FROM
fieldreport.fieldreport_localid,
imsmaenum.enumvalue,
fieldreport.dateofreport AS `"Date of Information`",fieldreport.reportreceiveddate AS `"Data Entry Date`",fieldreport.reportcompleteddate AS `"Submitted Date`",fieldreport.reportverifieddate AS `"Approved Date`",fieldreport.dataenterer AS `"Data enterer`",fieldreport.verifiedby AS `"Approved by`",
hazreducinfoversion.hazreduc_localid
FROM
fieldreport.fieldreport_localid,
imsmaenum.enumvalue,
fieldreport.dateofreport AS `"Date of Information`",fieldreport.reportreceiveddate AS `"Data Entry Date`",fieldreport.reportcompleteddate AS `"Submitted Date`",fieldreport.reportverifieddate AS `"Approved Date`",fieldreport.dataenterer AS `"Data enterer`",fieldreport.verifiedby AS `"Approved by`",
locationinfoversion.location_localid
FROM
fieldreport.fieldreport_localid,
imsmaenum.enumvalue,
fieldreport.dateofreport AS `"Date of Information`",fieldreport.reportreceiveddate AS `"Data Entry Date`",fieldreport.reportcompleteddate AS `"Submitted Date`",fieldreport.reportverifieddate AS `"Approved Date`",fieldreport.dataenterer AS `"Data enterer`",fieldreport.verifiedby AS `"Approved by`",
mreinfoversion.mre_localid
FROM
fieldreport.fieldreport_localid,
imsmaenum.enumvalue,
fieldreport.dateofreport AS `"Date of Information`",fieldreport.reportreceiveddate AS `"Data Entry Date`",fieldreport.reportcompleteddate AS `"Submitted Date`",fieldreport.reportverifieddate AS `"Approved Date`",fieldreport.dataenterer AS `"Data enterer`",fieldreport.verifiedby AS `"Approved by`",
qainfoversion.qa_localid
FROM
fieldreport.fieldreport_localid,
imsmaenum.enumvalue,
fieldreport.dateofreport AS `"Date of Information`",fieldreport.reportreceiveddate AS `"Data Entry Date`",fieldreport.reportcompleteddate AS `"Submitted Date`",fieldreport.reportverifieddate AS `"Approved Date`",fieldreport.dataenterer AS `"Data enterer`",fieldreport.verifiedby AS `"Approved by`",
victiminfoversion.victim_localid
FROM
<pre>
update fieldreport
Inner Join hazardinfoversion ON hazardinfoversion.fieldreport_guid = fieldreport.fieldreport_guid