title: SQL JOIN or UNION on same id
body: <p>Hi how to get from two tables </p>
  
  <pre><code> | id | name  |
   |----|-------|
   | 1  | John  |
   | 1  | Bruce |
   | 1  | Tom   |
  </code></pre>
  
  <p>and </p>
  
  <pre><code> | id | goal  |
   |----|-------|
   | 1  | 11    |
   | 1  | 22    |
  </code></pre>
  
  <p>get select with a result like</p>
  
  <pre><code> | id | name |goal  |
   |----|------|------|
   | 1  |John  | 11   |
   | 1  |Bruce | 22   |
   | 1  |Tom   |      |
  </code></pre>
  
  <p>I tried joins and union but i didnt get any result, please help! Using oracle pl/sql.</p>