title: Invalid Expression term Where
body: <p>I have following LINQ statement:</p>
  
  <pre><code>from o in Orders
                      join od in OrderDetails on o.OrderNumber equals od.OrderNumber
                      join r in RMAs on o.OrderNumber equals r.OrderNumber
                      join rd in RMADetails on r.RMAnumber equals rd.RMAnumber
                      from i in Inventory 
                      where( a =&gt; ( od.SKU == a.LocalSKU)).DefaultIfEmpty()//error is here
                      where (r.Status != "Pending" &amp;&amp; od.Adjustment == false)
                      select new
                      {
                          r.Status,
                          o.Name,
                          o.Company,
                          o.Address,
                          o.Address2,
                          o.City,
                          o.State,
                          o.Country,
                          o.Email,
                          o.Zip,
                          o.Phone,
                          o.ShipName,
                          o.ShipCompany,
                          o.ShipAddress,
                          o.ShipAddress2,
                          o.ShipCity,
                          o.ShipCountry,
                          o.ShipState,
                          o.ShipPhone,
                          o.ShipZip,
                          o.OrderNumber,
                          o.ShippingTotal,
                          OrderDate = o.OrderDate,
                          SerialNumbers = rd.SerialNumbers ?? "",
                          o.SourceOrderID
  
                      }
  </code></pre>
  
  <p>It's giving <code>Invalid Where term</code>. What I want to use LEFT OUTER JOIN having SQL Equivalent <code>left join Inventory i on od.SKU = i.LocalSKU</code></p>