title: Need help Grouping and creating a select statement in Microsoft SQL Server
body: <p>I have 3 tables with these structures:</p>
  
  <p><a href="https://i.stack.imgur.com/HxzDo.gif" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HxzDo.gif" alt="enter image description here"></a></p>
  
  <p>And the result that I am looking for is this:</p>
  
  <p><a href="https://i.stack.imgur.com/OY57w.gif" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OY57w.gif" alt="enter image description here"></a></p>
  
  <p>I have tried multiple grouping statements but I have not been able to get near to something to the structure I need, if anybody can give me hand.  Thanks</p>