title: Left outer join not working
body: <p>Hello all I have below tables -</p>
  
  <p>tr_resource as res -</p>
  
  <pre><code>Resourceid  name
  135021          ABC
  </code></pre>
  
  <p>tr_charac as chlev - </p>
  
  <pre><code>characid   name
  1          CH1
  2          CH2
  </code></pre>
  
  <p>tr_characvalue as cvlev -</p>
  
  <pre><code>characvalueid characid stringvalue
  cv1             1       XX
  cv2             2       YY
  cv3             2       zz
  </code></pre>
  
  <p>tr_resourcecharac as rchlev -</p>
  
  <pre><code>resourceid  characvalueid
  135021          cv2
  </code></pre>
  
  <p>When i run below query -</p>
  
  <pre><code>select 
      res.name,
      cvlev.stringvalue
  from tr_resource res
      left outer join tr_resourcecharac rchlev on res.RESOURCEID = rchlev.RESOURCEID
      inner join tr_characvalue cvlev on  rchlev.CHARACVALUEID = cvlev.CHARACVALUEID 
      inner join tr_charac chlev on chlev.CHARACID = cvlev.CHARACID and chlev.NAME = 'CH2'
   where res.resourceid=135021
  </code></pre>
  
  <p>I am getting answer as -</p>
  
  <pre><code>name  stringvalue
  ABC      YY
  </code></pre>
  
  <p>but when i run below query, i am not getting any answer -</p>
  
  <pre><code>select 
      res.name,
       cvlev.stringvalue
   from tr_resource res
       left outer join tr_resourcecharac rchlev on res.RESOURCEID = rchlev.RESOURCEID
       inner join tr_characvalue cvlev on  rchlev.CHARACVALUEID = cvlev.CHARACVALUEID 
       inner join tr_charac chlev on chlev.CHARACID = cvlev.CHARACID and chlev.NAME = 'CH1'
   where res.resourceid=135021
  </code></pre>
  
  <p>I want to get answer as -</p>
  
  <pre><code>name  stringvalue
  ABC      null
  </code></pre>
  
  <p>Could you please help?</p>