I am trying to populate a ViewModel in an MVC app with data from a parent table joined with a child table. The only data I want from the child table is a comma diliminated string from the Nomenclature field of the top three records and put them into a string field in the ViewModel. Here is what I have tried without success:

```
public IEnumerable<ReqHeaderVM> GetOpenReqs(string siteCode)
    {
      var openReqs = from h in context.ReqHeaders
      join l in context.ReqLineItems on h.ID equals l.ReqID into reqLineItems
       select new ReqHeaderVM
       {
         ReqID = h.ID,
         ShopCode = h.ShopCode
         Nomenclatures = reqLineItems.Select(x => x.Nomenclature).Take(3) // This doesn't work

       };
        return (openReqs.ToList());
    }     

```

Here is the ViewMdel:

```
    public class ReqHeaderVM
{
    [Editable(false)]
    public string ReqID { get; set; }
    public string ShopCode { get; set; }
    public string  Nomenclatures {get; set;}

}

```