title: Accessing Outer Table inside 2nd Level Nesting Sub Query
body: <p>Let's say I have,</p>
  <pre><code>select 
      (select SomColumn FROM MyInnerTable WHERE MyInnerTable.C1 = MyOuterTable.C2) AS FirstColumn
      ,(select SomColumn FROM (SELECT SomColumn FROM MyInnerTable2 WHERE MyInnerTable2.C1 = MyOuterTable.C2)) AS SecondColumn
  form MyOuterTable
  </code></pre>
  <p>FirstColumn works but for SecondColumn its says MyOuterTable.C2 not found.</p>