MySql Update One column from another table value

// Nazmus Sakib
// Datacraft Ltd

UPDATE customer_info SET `Approved_Datetime` = (SELECT `DateTime` FROM `file_process_info` WHERE `movingReason` LIKE 'Approved'
GROUP BY fileSerial ORDER BY id DESC)
WHERE customer_info.fileSerial = file_process_info.fileSerial