php - MySQL update query join and join left

Question

I know basics of mysql and need help in updating query where select query is this:

SELECT f.FinalAmount,f.ActualAmount,fh.ActualPaid,p.Name package,f.FromDate,f.ToDate 
from customers c 
join fees f on f.CustomerID = c.ID 
join packages p on p.ID=f.PackageID 
left join fees_history fh on f.ID = fh.ReferenceID  
where c.ID='108239' and c.branch='664'

I want to update f.FromDate but know know How to do that because the SELECT statement need join query.

question from:https://stackoverflow.com/questions/65881757/mysql-update-query-join-and-join-left

Answer 1

Directly:

UPDATE 

       customers c 
join fees f on f.CustomerID = c.ID 
join packages p on p.ID=f.PackageID 
left join fees_history fh on f.ID = fh.ReferenceID  

SET f.FromDate = ???

where c.ID='108239' and c.branch='664'

PS. left join fees_history fh on f.ID = fh.ReferenceID does not affect the update and must be removed.