title: How to use result set from one query and query the same table
body: <p>I have the following scenario:</p>
  <p>I would like to return all manual name from the table Manual that belong to userID of 1.</p>
  <p>Also if there is a subManualId  I would need to query this table over so that I could get this subManual Name from the same Manual table.</p>
  <p><strong>So my result should be:</strong></p>
  <p><strong>Test</strong> (There is NoSubmanual) so just display the name Test</p>
  <p><strong>Test1 &gt; Test3 &gt; Test4</strong>  (Test1 as a Submanual Test3 and Test3 as a Submanual Test4)</p>
  <p>I'm not sure on how to really tackle this problem...</p>
  <p>Table: MANUAL</p>
  <pre><code>manualId        Name       SubManualId   userID
      1123        Test                          1
      1124        Test1       1125              1          
      1125        test3       1126              1
      1126        test4                         1
      1127        Test5
  </code></pre>