<p>I put together a sample scenario of my issue and I hope its enough for someone to point me in the right direction.</p>

<p>I have two tables</p>

<p>Products</p>

<p><img src="https://i.stack.imgur.com/ktnI0.gif" alt="alt text"></p>

<p>Product Meta</p>

<p><img src="https://i.stack.imgur.com/dBrc0.gif" alt="alt text"></p>

<p>I need a result set of the following</p>

<p><img src="https://i.stack.imgur.com/Ken2R.gif" alt="alt text"></p>

```
```
Select a.ProductId
  ,a.Name
  ,(Select c.MetaValue
    From [Product Meta] c
    Where c.ProductId = a.ProductId
    And c.MetaKey = 'A') As 'A'
   ,(Select d.MetaValue
    From [Product Meta] d
    Where d.ProductId = a.ProductId
    And d.MetaKey = 'B') As 'B'
   ,(Select e.MetaValue
      From [Product Meta] e
      Where e.ProductId = a.ProductId
      And e.MetaKey = 'C') As 'C'
From Products a
Order By a.ProductId Asc
```
```