title: add primary row to query results
body: <p>How do I add a primary row  to a query result in MSSQL 2005. Here's an example of what I need to return?</p>
  
  <p>Here are the two queries</p>
  
  <p>query 1</p>
  
  <pre><code>select product_id, sku from products
  </code></pre>
  
  <p>query 2 </p>
  
  <pre><code>select product_id, sku from childproducts
  </code></pre>
  
  <p>The results should look like this. (without the query 1, of course)</p>
  
  <pre><code>    row 1: products.product_id, products.sku   (comes from one parent table)
      row 2: childproducts.product_id, childproducts.sku   (comes from child table)
      row 3: childproducts.product_id, childproducts.sku   (comes from child table)
  </code></pre>