title: 'Shape - append' queries equivalence nowdays
body: <p>I have been converting a program written in VB to C# in the last few weeks.
  In some places I noticed queries written in a weird way, the words 'Shape' and 'Append' appeared.
  For instance:</p>
  
  <pre><code>SHAPE {SELECT Test, IdQuestion, QuestionName, QuestionTimeLimit, ImageLocation 
  FROM dbo.userViewConTestQues 
  WHERE (Test = 5) ORDER BY QuestionOrder} AS ParentCMD APPEND ({SELECT Answer, 
  IdAnswer, Question FROM dbo.userAnswers } AS ChildCMD RELATE IdQuestion TO Question) AS ChildCMD
  </code></pre>
  
  <p>I was totally sure that the equivalence for that query would be an INNER JOIN, something like:</p>
  
  <pre><code>SELECT A.Test, A.IdQuestion, A.QuestionName, A.QuestionTimeLimit, A.ImageLocation,
  B.Answer, B.IdAnswer FROM dbo.userViewConTestQues A INNER JOIN 
  dbo.userAnswers B ON A.IdQuestion=B.Question WHERE A.Test=5 ORDER BY A.QuestionOrder
  </code></pre>
  
  <p>After debugging I got the following results:
  The record count of the old program was 60, which means 60 rows, while running the new query I wrote got me more than 400 rows, so I guess I was wrong. 
  What would be the 'Shape - append' equivalence nowdays?</p>
  
  <p>EDIT:
  60 Rows belong only to the parent recordset, however the child's recordset count is 6, but I have no idea how to get them. </p>