title: Linq multiple join on same table
body: <p>how can i write this query in linq?</p>
  
  <pre><code>select * from bills as b inner join customer as c1
            On b.shipperID=c1.CustomerID inner join customer c2
            On b.ConsigneeID=c2.CustomerID      
  ---------------------------
  </code></pre>
  
  <p>I need to have it as below:</p>
  
  <pre><code>var result=from p1 in entities.bills
             join p2 in entities.customer on p1.shipperID equals p2.customerID
             join p3 in entities.customer on p1.consigneeID equals p3.customerID
             select p2;
             return resuls.Tolist()
  </code></pre>
  
  <p>Thanks:)</p>