title: VB.Net Linq To SQL Sub Select
body: <p>I have the following query which groups some records and then filters where the count of the grouped records is 1.</p>
  
  <p>I'd like to take the returned result and perform another query to retrieve the entire record from the JobcodesWorkingRollup table where the ParentNode column equals the result of this query:</p>
  
  <pre><code>        Dim query = From r In context.GetTable(Of JobcodesWorkingRollup)() _
          Group r By r.ParentNode Into g = Group _
          Where g.Count = 1 _
          Select New With {.cnt = g.Count, .nm = g.FirstOrDefault.ParentNode}
  </code></pre>
  
  <p>Thanks!</p>