Need to update Table columns using View in Oracle

Question

Hi All,

 

I Need to update the columns values of Table FIRETABLE with the View FCAM_SITES_V with inner join of other tables 

But not able to do it, Kindly please suggest what wrong with the below query? I am getting Errro in the FROM

 

Please provide your solutions asap. Correct the Query as well

 

Update Query: 

Update FIRETABLE SET
FFM.TECHNICAL_SQUARE_FEET = FSV.TECHNICAL_SQUARE_FEET,
FFM.COMMON_SQUARE_FEET = FSV.COMMON_SQUARE_FEET ,
FFM.ROOF_REPAIRED_DATE = FSV.ROOF_REPAIRED_DATE,
FFM.RAISED_FLOOR = FSV.RAISED_FLOOR,
FFM.YEAR_BUILT = FSV.YEAR_BUILT,
FFM.NUMBER_OF_BUILDINGS = FSV.NUMBER_OF_BUILDINGS,
FFM.OCCUPIED_FLOORS = FSV.OCCUPIED_FLOORS
FROM
FIRETABLE FFM
INNER JOIN
SITES_MAPPING FSM
ON FFM.FACILITY_ID = FSM.FACILITY_ID
INNER JOIN
FCAM_SITES_V FSV
ON FSV.SITEID=FSM.FACILITY_SITE_ID;
COMMIT;