Producing queries based on user interface selection
Company_contacts.Any(x =&gt; x.Company_contacts.Cust_order_header.Any(y =&gt; y.Order_time &gt;= @0))

That should put the joins in for you. Right now it is not referencing the objects you use in the query through their relationships so it is writing the SQL out as though they were subqueries.