title: SQL JOIN with UPDATE
body: <p>i have two tables TBL_TEST1 and TBL_TEST2 with columns DISTRICT and NAME in both tables, there are data in both tables in column DISTRICT which are same i want to update TBL_TEST2  all NAME column values to 'Done' where in TBL_TEST2 table in its DISTRICT value '1' found in both tables.</p>
  
  <p>below are my tables with query</p>
  
  <pre><code>SELECT * FROM TBL_TEST1
  
  DISTRICT    NAME
  1           Rashid
  2           Ramish
  1           Ali
  1           Karim
  </code></pre>
  
  <p>And</p>
  
  <pre><code>SELECT * FROM TBL_TEST2
  
  DISTRICT    NAME
  1           DDD
  2           DDDY
  3           DDDD7
  1           DD1
  1           DDD4
  </code></pre>
  
  <p>When i try</p>
  
  <pre><code>  UPDATE TBL_TEST2 SET TBL_TEST2.NAME = 'DONE'  FROM TBL_TEST2 INNER JOIN TBL_TEST1 ON TBL_TEST2.DISTRICT = TBL_TEST1.DISTRICT WHERE TBL_TEST2.DISTRICT = '1'
  </code></pre>
  
  <p>i receive error msg below</p>
  
  <pre><code>ORA-00933: SQL command not properly ended
  </code></pre>
  
  <p>i tested codes which are in other posts, i am asking that however my code is correct why i am still receiving that error msg</p>