title: How to insert with where clause
body: <p>I am using the following query to insert values into one field in table A.</p>
  
  <pre><code>insert
  into A (name)
  values ('abc')
  where
     A.id=B.code
     and B.dept='hr' ;
  </code></pre>
  
  <p>Is this query right?
  If not, please provide me a correct way.</p>