php - MySQL更新查询join和join left

Question

我知道 mysql 的基础知识，需要帮助更新查询，其中选择查询是这样的：

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'

我想更新f.FromDate但知道该怎么做，因为 SELECT 语句需要连接查询。

标签： phpmysql

Answer 1

直接地：

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不影响更新，必须删除。