title: LINQ Help for a novice
body: <p>not able to get this, can someone help for this LINQ query?</p>
  
  <pre><code>select col1, 
  (select col2 from tbl2 where tbl2.ID=tbl1.tbl2ID) as [col2] 
  from tbl1  
  </code></pre>
  
  <p>scenario is like this</p>
  
  <p>I want all records from Jobs table, Jobs has sectorID column, I also want SectorName. Also it has CountryID and CityID and I need CountryName and CityName too.</p>