title: SQL Join, display results from each table in a separate row
body: <p>I need to be able to select each line from an invoice and display in separate rows. There are two types of lines, normal line and custom line. </p>
  
  <p>To clarify, Each booking has one Cart booking that owns many Product bookings, each product booking can only have one invoice which can have both multiple  normal(BokunProductInvoiceLine) lines and custom lines.</p>
  
  <p>Here is the code:</p>
  
  <pre><code>Select 
  CB.ConfirmationCode as 'Confirmation Code',
  PB.ProductConfirmationCode as 'Product ConfirmationCode',
  BPL.[Title] as 'Normal line title',
  BPL.[CostGroupTitle] as 'Normal line title',
  CL.Title as 'Custom line title'
  
  From [dbo].[BokunProductBooking] PB
  Join [dbo].[BokunCartBooking] CB
  On Pb.ParentBookingId = CB.Id
  Join [dbo].[BokunInvoice] BI
  On Bi.BookingId = PB.Id  AND BI.Active = 1
  left Join BokunCustomLine CL
  On CL.InvoiceId = BI.Id
  FULL JOIN BokunProductInvoiceLine BPL
  On BPL.ProductInvoiceId = BI.Id
  </code></pre>
  
  <p>Here is the result I am getting with this query:
  <a href="https://i.stack.imgur.com/PVTJP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PVTJP.png" alt="enter image description here"></a></p>
  
  <p>And here is the result I am trying to get:
  <a href="https://i.stack.imgur.com/zsmyt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zsmyt.png" alt="enter image description here"></a></p>
  
  <p>Thanks :)</p>