I have been created two tables namely ‘Tab1’ and ‘Tab2’ in SQL Plus 8.0 and inserted some data i.e.

Tab1.
id.	name		sal	
1	ABC		1500
2	XYZ		2000
3	JKL		2500

Tab2.
id.	inc	
1	500

Problem is that when I perform ‘UPDATE’ statement based on both tables for arithmetic operation then I got two types of error like:
ORA-00904: invalid column name 
ORA-00933: SQL command not properly ended. 

Both version of code are as follow:

SQL> UPDATE tab1
2   SET  sal = sal + tab2.inc;

set sal=sal + tab2.inc
                   *
ERROR at line 2:
ORA-00904: invalid column name

Second version of Update statement 

  1  UPDATE t1
  2  SET t1.sal=t1.sal+t2.inc
  3  FROM tab1 t1
  4  INNER JOIN tab2 t2
  5  on t2.id=t1.id;


SQL> /
FROM tab1 t1
*
ERROR at line 3:
ORA-00933: SQL command not properly ended