title: SQL: Recursive Path
body: <p>Is it possible to create a "tree resolver" in SQL?</p>
  
  <p>I have a table:</p>
  
  <pre><code>ID Name Parent
  1  a
  2  b    1
  3  c    1
  4  d    3
  </code></pre>
  
  <p>Now I want a SQL query that returns:</p>
  
  <pre><code>ID   PATH
  1    /a
  2    /a/b
  3    /a/c
  4    /a/c/d
  </code></pre>
  
  <p>Is this possible with SQL? It would make many things easier for me. Any help would really be appreciated!</p>