title: How do I select one parent row and additional rows for its children without a UNION?
body: <p>I have a parent and child table and want to create a select statement that, given a parent id, returns a row for that parent and <strong>additional rows</strong> for every child. Doing a left join is not giving me a row for the parent by itself when one or more children exist. I know this can be done with a UNION but I'm looking for a solution that <strong>does not</strong> use a union statement. Is this possible?  </p>
  
  <p>[Parent Table]</p>
  
  <pre><code>ID     Name
  -------------
  1    | Bob
  </code></pre>
  
  <p>[Child Table]</p>
  
  <pre><code>ID     ParentId   Name
  -----------------------
  1    | 1        | Jim    
  2    | 1        | Ned  
  </code></pre>
  
  <p>Query result I'm looking for:</p>
  
  <pre><code>Parent_Name   Child_Name
  ---------------------------
  Bob         | NULL &lt;- I need this null here
  Bob         | Jim
  Bob         | Ned
  </code></pre>