title: How do i create a specific one many view using Microsoft SQL Server
body: <p>I have a master table and a detail table.</p>
  <p>Question 1: I would like my view to look like this</p>
  <pre><code>master1 row, nulls
  master1 row, detail1 row for master1
  master1 row, detail2 row for master1
  master1 row, detail3 row for master1
  master2 row, nulls
  master2 row, detail1 row for master2
  master2 row, detail2 row for master2
  </code></pre>
  <p>Question 2: how can I insert a column at the beginning of each row that tells me when a row is a master only row and when a row is a master / detail row?</p>
  <p>Thanks for any help, it is much appreciated</p>