title: How to use result of join in Linq
body: <p>I have this SQL query and I want to use the same in Linq. I am confused as to how they use the group join alias in the main query?</p>
  
  <pre><code>SELECT '1st' AS POSITION , user as USR1, actiondate as ad1 , user2 as USR2, actiondate2 as ad2 ,user3 as USR3, actiondate3 as ad3, First as Co, * FROM APPLICATIONS A INNER  JOIN
      ( SELECT MAX(ROW) AS MAXDATE ,APPLICATIONNO FROM FIRSTM
      GROUP BY APPLICATIONNO) SULA1
      ON A.APPLICATIONNO=SULA1.APPLICATIONNO
      INNER JOIN FIRSTM FSTATUS
      ON SULA1.APPLICATIONNO=FSTATUS.APPLICATIONNO AND
      SULA1.MaxDate = FSTATUS.ROW
      INNER JOIN APPLICATIONAPPLICANTS ON A.APPLICATIONNO
       =APPLICATIONAPPLICANTS.APPLICATIONNO
  </code></pre>