title: Columns in from one table is only Required
body: <p>I have written the below and noticed that it is bringing back all the columns from both tables <strong>OrderItems</strong> and <em>Order</em> where I only want all the columns from the <strong>OrderItem</strong> table.</p>
  <pre><code>`SELECT * FROM [OrderItem] oi INNER JOIN
   [Order] o
   ON o.[pkOrderID] = oi.[fkOrderID]
   WHERE [dReceievedDate] BETWEEN @StartDate AND @EndDate;`
  </code></pre>
  <p>There is a one to many relationship from the Order table to the OrderItem table, so any help on this is much appreciated.</p>