Missing approval information

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`

FROM fieldreport Inner Join imsmaenum AS workbench_status ON (workbench_status.imsmaenum_guid = fieldreport.workbenchstatusenum_guid)

WHERE workbench_status.enumvalue = 'Approved' AND

(fieldreport.reportverifieddate IS NULL OR

fieldreport.verifiedby IS NULL )

ORDER BY fieldreport.fieldreport_localid ASC

---

UPDATE fieldreport Inner Join imsmaenum AS workbench_status ON (workbench_status.imsmaenum_guid = fieldreport.workbenchstatusenum_guid) SET fieldreport.reportverifieddate = reportreceiveddate, fieldreport.verifiedby = fieldreport.dataenterer WHERE workbench_status.enumvalue = 'Approved' AND (fieldreport.reportverifieddate IS NULL OR fieldreport.verifiedby IS NULL )