SQL & PL/SQL

Hi Guys,

I have a custom table which needs to be updated from a source table "abc";

I have to update 8 fields from "abc" based on five keys matching between the custom record and abc record

below is the syntax that I an following please let me know the efficient way of doing this.

I am getting error for the below syntax.I think "FROM" keyword should not be use rgt???

update custom table a

set a.field1=b.field1,a.field2=b.field2,a.field3=b.field3

from abc b

where value='05'