title: Multiple table queries
body: <p>I am having problems with creating a query.</p>
  
  <p>What I am trying to achieve is create a query which conforms to the following criteria</p>
  
  <pre><code>   Show all records in table house where 
  tbl_house.townId =tbl_town.townId 
  and house.type = “3bedrooms”
  </code></pre>
  
  <p>What I have tried so far </p>
  
  <pre><code> var house = 
      From m in db.tbl_house 
      Where m.townId ==  tbl_town.townId &amp;&amp; m.Bedrooms == "3bedrooms" 
                     Select m
  </code></pre>
  
  <p>Any help or advice will be appreciated </p>
  
  <p>update</p>
  
  <p>There are three estate agencies one, two and three
  There is an account for each estate agency so when the estate agency logs on I want to only show 
  Houses for that town with a specified housetype.</p>
  
  <p>All houses have a townID</p>
  
  <p>Example:  house 1 could have a townId of 3 which   = town3  and a housetype = “3bedrooms”</p>
  
  <p>house 2 could have an townId of 3 which   = town3 and a housetype = “2bedrooms”</p>
  
  <p>house 3 could have an townId of 4 which   = town4  and a housetype = “2bedrooms”</p>
  
  <p>So what I am trying to do is select all houses with a townId of 3 and a housetype =”3bedrooms”
  And show them for the estate agency which has the townId of 3 associated with it.</p>