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;
Murali KrishnanPosted May 16, 2021, 9:36 AM