title: Inner joins in Ebean?
body: <p>I read <a href="https://archive-avaje-org.github.io/ebean/introquery_joinquery.html" rel="nofollow noreferrer">https://archive-avaje-org.github.io/ebean/introquery_joinquery.html</a>  looking at Example A, I noticed there's no specification of the inner join common column.  I think their fetch-tablename syntax causes Ebean to look at what column the 2 tables have to inner join on.  Then they are storing each result as an Order?  They are joining 2 tables, so how can they store columns from the customer table as an Order?</p>
  
  <p>I tried to do an inner join with ebean in my code and discovered at least one of my assumptions was wrong.  I have 2 tables, a Street table and a House table(one to many relationship).  The street_id column in the House table is the foreign key to the id column of the Street table.  I'm trying to come up with the Ebean equivalent of this sql:</p>
  
  <pre><code>SELECT s.name, h.owner, h.isSubscriber FROM Street as s INNER JOIN House as h WHERE     
  h.street_id=s.id AND h.isNew='false'
  </code></pre>