title: Updating a column in one table through a column in another table
body: <p>I have 2 tables 'A' and 'B'. Both have a common column 'name' and linked with each other by a column 'id'. The column 'name' in the table A is empty whereas it has data in table B. My task is to fill all the data in that column from table B to table A with corresponding ids.</p>
  
  <p>I'm using the following query:</p>
  
  <pre><code>UPDATE A
  SET A.name = (SELECT B.name from B WHERE A.id = B.id)
  WHERE EXISTS
  (SELECT B.name from B)
  </code></pre>
  
  <p>As soon as I run the query in SQL developer, it just freezes and i have to force close it. Can anyone tell me what's wrong with the query?</p>