title: left outer joining three tables in oracle
body: <p>I have three tables like shown below:</p>
  
  <p><img src="https://i.stack.imgur.com/SGk3r.png" alt="enter image description here"></p>
  
  <p>And i am trying to get output like below:</p>
  
  <p><img src="https://i.stack.imgur.com/S1lxR.jpg" alt="enter image description here"></p>
  
  <p>Here is what i have tried till now</p>
  
  <pre><code>    SELECT table1.tb1_a,
  CASE WHEN table3.tb3_a IS NOT NULL THEN
      tb3_b
      ELSE 'No city for him yet'
  END AS 'City'
  FROM table1
  LEFT OUTER JOIN table2 ON
      table1.tb1_a = table2.tb2_a
  LEFT OUTER JOIN table3 ON
      table2.tb2_a = table3.tb3_a
  WHERE table3.tb3_a IN
      (
  
      )
  </code></pre>
  
  <p>And now i am struggling on how to select the maximum value of the tb3_a column</p>