title: Left Join Linq to Entity's Vb.net
body: <p>I can't figure out that linq to entity query syntax. My problem is that if the value of the Calls table is null then noting comes up, I want to make something like a left join to get 'all' rows from the Calls table.</p>
  
  <p>I tried to group it but I can't figure out the correct way to write it.</p>
  
  <pre><code>Dim TicketQuery As ObjectQuery = From c In EnData.Customer _
                                           Join t In EnData.Calls On t.CustomerID Equals c.CustomerID _
                                           Join Status In EnData.Lists On t.Status Equals Status.ListValue _
                                           Join Project In EnData.Lists On t.Project Equals Project.ListValue _
                                           Join Priorty In EnData.Lists On t.Priority Equals Priorty.ListValue _
                                           Where c.Status &gt; -1 And t.Status &gt; -1 And Status.ListType = 1 And Project.ListType = 3 And Priorty.ListType = 2 _
           Select New With {c.CustName, t.CallID, t.CallDate, t.CallTime, t.Description, Key .Status = Status.ListText, Key .Project = Project.ListText, t.DateModified, Key .Priority = Priorty.ListText}
  </code></pre>
  
  <p>How can I fix that?</p>