title: Only returns 1 row?
body: <p><a href="https://i.stack.imgur.com/v8f5G.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/v8f5G.jpg" alt="This is the table containing the data" /></a></p>
  <p><a href="https://i.stack.imgur.com/Eaa4Z.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Eaa4Z.jpg" alt="This is my command" /></a></p>
  <p>Picture 1 is the table containing the data</p>
  <p>Picture 2 is my command</p>
  <p>Why is it only returning 1 row and not the same for all the subjectIDs?
  How do I make it return a row for each subjectID?
  Thanks</p>
  <p>p.s Please keep things simple I need to do this with basic sql.</p>