title: Oracle Update query with join
body: <p>There are tow tables. first one is <strong>expenses</strong> and second one is <strong>expenses_items</strong>.</p>
  
  <p>There are 2 columns in <strong>expenses</strong> table as <code>expns_id</code> and <code>expns_job_type</code>.</p>
  
  <p>There are 2 columns in <strong>expenses_items</strong> table as <code>expns_id</code> (foreign key from expenses table) and <code>group</code>.</p>
  
  <p>I need to update <code>group</code> in <code>expenses_items</code> table and set it's value as <code>development</code> where value of <code>expns_job_type</code> in <code>expenses</code> table like <code>new building</code>.</p>
  
  <p>I have tried below query. but not worked.</p>
  
  <pre><code>update expenses_items
  set expenses_items."group" = 'development'
   join expenses ON 
   expenses_items.expns_id = expenses.expns_id 
  where expenses.expns_job_type like 'new building'
  </code></pre>
  
  <p>How could i do this ?</p>