title: One-to-many relationship using same SQL table
body: <p>I'm in the process of designing my database and one of the Tables (Tasks), needs to be able to have a one-to-many relationship with itself. This is because a task can have a number of sub-tasks that have the same data (much like a question and answer on SO).</p>
  
  <p>I'm just a little confused, due to my not very strong SQL, as to how to make a one-to-many on the same table.</p>
  
  <p>Currently I have these rows:</p>
  
  <blockquote>
    <p>TaskId (uniqueidentifier)<br>
    aspnet_OwnerUserId (uniqueidentifier)<br>
    Title (nvarchar(50)) 
    Description (nvarchar(MAX))<br>
    StartDate (smalldatetime)<br>
    DueDate (smalldatetime)</p>
  </blockquote>