title: joining inner join and outer join in one query in oracle
body: <p>I am trying to join 7 tables in a select query four with inner join and two with outer join.</p>
  
  <p>Can I combine outer and inner join in the same query? Because when I am doing so i am not getting proper results. I tried with both ANSI joins ( INNER JOIN , LEFT OUTER JOIN) and with + sign as well. I am wondering is the order of joining is important in ANSI joins?</p>
  
  <p>so here is the scenario,</p>
  
  <p>table a 
  table b
  table c
  table e
  table f
  tanle g
  table h</p>
  
  <p>inner join ( a , b, c )</p>
  
  <p>inner join ( a , e , f)</p>
  
  <p>left outer outer join ( f , g)</p>
  
  <p>left outer join ( f , h)</p>
  
  <p>My query ( which looks wrong) _==></p>
  
  <pre><code>FROM a inner join   b on (a.col_1 = b.col_1)
    inner join  c on (b.y = c.y)
    inner join  e on ( a.col_1      = e.col_1)
    inner join   f on (e.col_4   = f.col_4)
    left outer join  g on (g.col_5= f.col_5)
    left outer join  h on (h.col_6 = f.col_6)
  </code></pre>
  
  <p>Could any one please help me with the correct joining query?
  Any lead would be highly appreciated</p>