SQL & PL/SQL

Hi,

I have an update statement that is supposed to update a table from another table based on one condition.

------------------------------------------------------------------------

UPDATE TABLE_1 -- The Table to be updated 

FROM TABLE_2 T  -- The table with the info with an Alias 'T'

SET SERVICE_ID_CLEANSED = T.SERVICE_ID_CLEANSED  -- Enter the value from the info table

WHERE SERVICE_ID_1 = T.SERVICE_ID_DIRTY;  --- Based on this condition

-----------------------------------------------------------------------

I get a 'Missing SET Keyword' error.

The sites I've visited advise that the issue may be that the 'SET' keyword should be after the Update table name, but I haven't been able to make any changes work ...

So, I need to find out why I get the Missing SET keyword error & fix it.

Any suggestions about why this is wrong??

Thanks