title: How to work this nested relationship in Room?
body: <p>I could use a little help.
  I have created all the tables, and I can create a relationship to retrieve the application, but I do not know how I can retrieve the list of vehicle brands with the models.</p>
  <p><a href="https://i.stack.imgur.com/hGZd7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hGZd7.png" alt="enter image description here" /></a></p>
  <pre class="lang-kotlin prettyprint-override"><code>@Entity(tableName = &quot;application_table&quot;, indices = [Index(value = [&quot;name&quot;], unique = true)])
  data class ApplicationItem(
      @PrimaryKey(autoGenerate = true)
      @ColumnInfo(name = &quot;id&quot;) val id: Int? = 0,
      @ColumnInfo(name = &quot;name&quot;) val name: String
  )
  </code></pre>
  <pre class="lang-kotlin prettyprint-override"><code>data class ApplicationWithBrandAndModel(
      @Embedded val application: ApplicationItem,
      @Relation(
          entity = BrandOfVehicleItem::class,
          parentColumn = &quot;userId&quot;,
          entityColumn = &quot;brandId&quot;
      )
      val brands: List&lt;BrandWithModel&gt;
  )
  </code></pre>
  <pre class="lang-kotlin prettyprint-override"><code>data class BrandWithModel(
      @Embedded val brand: BrandOfVehicleItem,
      @Relation(
          parentColumn = &quot;path&quot;,
          entityColumn = &quot;brandCreatorId&quot;
      )
      val models: List&lt;ModelOfVehicleItem&gt;
  )
  </code></pre>