title: Convert nested join sql query to nested join LINQ
body: <p>I am trying to convert nested join sql query to linq. I need some help to convert the query into linq. I am using vb.net.
  This is my sql query:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT tblJobSkillMatrix_JS.fldJobTitleID,
         tblRSCFMainLevel.fldRSCFMainLevel, 
         tblRSCFSkill.fldRCSFSkill, 
         tblSkillLevelDefinition.fldSkillLevelNum, 
         tblJobSkillMatrix_JS.fldPriorityJobSkill
  FROM ((tblJobSkillMatrix_JS 
  INNER JOIN (tblRSCFMainLevel 
        INNER JOIN tblRSCFSkill 
                ON tblRSCFMainLevel.fldRSCFMainLevelID = tblRSCFSkill.fldRSCFMainLevelID) 
        ON tblJobSkillMatrix_JS.fldRSCFSkillID = tblRSCFSkill.fldRSCFSkillID) 
  INNER JOIN tblSkillLevelDefinition ON 
             tblJobSkillMatrix_JS.fldSkillLevelID = tblSkillLevelDefinition.fldSkillLevelID) 
  INNER JOIN tblRSCFSkillGroupLevel ON
             (tblRSCFSkillGroupLevel.fldRSCFSkillGroupLevelID = tblRSCFSkill.fldRSCFSkillGroupLevelID) 
        AND  (tblRSCFMainLevel.fldRSCFMainLevelID = tblRSCFSkillGroupLevel.fldRSCFMainLevelID)
  WHERE (tblJobSkillMatrix_JS.fldJobTitleID='F74F5BCA-F33A-4AE1-9825-16B05AB274F4') 
    AND (tblRSCFMainLevel.fldRSCFMainLevel='People skills')
  ORDER BY tblJobSkillMatrix_JS.fldPriorityJobSkill;
  </code></pre>