第一种
UPDATE tblind
INNER JOIN tblind11
SET tblind.LOCFISCAL_TECHSPEND = tblind11.LOCFISCAL_TECHSPEND
WHERE tblind.AREA = tblind11.AREA
第二种
UPDATE tblind AS a,tblind11 AS b
SET a.LOCFISCAL_TECHSPEND = b.LOCFISCAL_TECHSPEND
WHERE a.AREA = b.AREA