I wonder if I can do this query in Oracle database?
UPDATE
Table_A SET
Table_A.col1 = Table_B.col1,
Table_A.col2 = Table_B.col2 FROM
Some_Table AS Table_A
INNER JOIN Other_Table AS Table_B
ON Table_A.id = Table_B.id WHERE
Table_A.col3 = 'cool'
this is working on sql server (microsoft). but cant work in oracle db. could you please tell me the reason ?