title: Copy column from one table to another table but it hangs DB Browser for SQLite
body: <p>I want to copy one table's column to another table's column with where condition that both employee id should be equal, more than 300k records.</p>
  
  <p>below is my query</p>
  
  <pre><code>UPDATE emp SET emp.address = (
      SELECT emp_address
      FROM address
      WHERE emp.emp_id=address.emp_id LIMIT 1
  );
  </code></pre>
  
  <p>I have executed this query since last 1 hour but still process is going on, I have executed this query on "DB  Browser for SQLite".</p>
  
  <p>Am I making any mistake? or there is problem with sqlite browser?</p>