title: SQL insert data with inner join using oracle
body: <p>New to SQL I have two tables <code>table_A</code> and <code>table_B</code>. </p>
  
  <p>I want to add data into a specific column of <code>table_A</code> depending on a <code>inner join</code> on <code>table_B</code>. I am using Oracle, following this <a href="https://stackoverflow.com/questions/2446764/update-statement-with-inner-join-on-oracle">method</a> my SQL looks like this : </p>
  
  <p>I first tried that : </p>
  
  <pre><code>INSERT INTO table_A (target_column)
  SELECT table_B.wanted_data 
  FROM table_B INNER JOIN table_A ON table_B.someColumnB = table_A.someColumnA
  </code></pre>
  
  <p>Here the issue is that it would insert the data in new lines of my <code>table_A</code> and not in the existing lines.</p>
  
  <p>So I tried that from the stackoverflow thread : </p>
  
  <pre><code>UPDATE(SELECT table_A.target_column, table_B.wanted_data
    FROM table_A
    INNER JOIN table_B
    ON table_A.someColumnA = table_B.someColumnB
  )
  SET table_A.target_table = table_B.wanted_data
  </code></pre>
  
  <p>But it is not working either "SQL command not properly ended"</p>
  
  <p><strong>EDIT :</strong> <code>target_column</code> and <code>wanted_data</code> have the same name in my data set, not sure if it changes anything.</p>