title: LINQ table join with entity Framework
body: <p>In my database I have ... TableA, TableB and TableC</p>
  
  <p>TableB has just 2 columns, the primary key of TableA and TableC, so it really defines a one to many relationship between the two tables</p>
  
  <p>What I want to do using SQL is:</p>
  
  <pre><code>SELECT * 
  FROM TablesA a
  JOIN TablesB b ON a.AID = b.AID
  WHERE b.BID = 1
  </code></pre>
  
  <p>In the Entity Framework it doesn't create a TablesB for me to do the join, I think because TableB only has foreign keys!</p>
  
  <p>So how can I do it?</p>