title: Room database INNER JOIN results
body: <p>I have two tables with a relation one to one</p>
  
  <p>For example : </p>
  
  <p>Tables : </p>
  
  <ul>
  <li>users [ u_id,u_name,u_address ]</li>
  <li>address [ add_id,add_country,add_town,add_street ]</li>
  </ul>
  
  <p>Which means two Entities and two DAO in my java code</p>
  
  <p>When i want to execute this query : <code>select * from users inner join address on u_address = add_id</code></p>
  
  <p>It will return </p>
  
  <pre><code>LiveData&lt;List&lt;ItemUser&gt;&gt;
  </code></pre>
  
  <p>And like that i'll get u_address which is just an ID instead of ItemAddress object where i can get the data that i want. </p>
  
  <p>I know that i can execute another method which can get the data of the selected address , but i want to know if it's possible to get the whole data by calling just one method ?</p>