title: Implementing a form of join query on a realm db without having a predefined relationship in structure
body: <p>I have used SQL engines and some noSQL engines as well like indexdb and it's possible to scrape data across several tables without defining foreign keys or something.</p>
  
  <p>My question is, is it possible to make a query to scrape data across objects tables in Realm without defining any special relationship in the structure? To express my self better, I'm going to post sample codes of what I'm wanting to achieve with Realm so you could help me.</p>
  
  <p>Implementation using dexie, an indexdb wrapper</p>
  
  <pre><code> db.quote_items.where('quote_id').equals(quote_id).then(function(a){
         db.products.where('id').equals(quote_id.product_id).then(function(){
             list.push({'id': a.id, 'product_name':a.product_name, 'product_code': a.product_code, 'quantity':a.quantity,  'tax':a.tax, 'unit_price':a.unit_price, 'val_tax':a.val_tax, 'discount_val':a.discount_val, 'gross_total':a.gross_total, 'details ':b.details   });
  
         }).catch(function (e) { console.log(e); alert("Sorry, Something went wrong"); })
     }).catch(function (e) { console.log(e); alert("Sorry, Something went wrong");})
  </code></pre>
  
  <p>Implementation in mysql</p>
  
  <pre><code>    SELECT quote_items.id AS id, quote_items.product_name AS product_name ...... FROM quote_items, products WHERE quote_items.quote_id = quote_id AND products.id = quotes_items.produc_id 
  </code></pre>
  
  <p>Expected implementation in Realm.io for Android</p>
  
  <pre><code>  RealmResults result = realm.where(quote_items.class)
              .equalTo("quote_id", quote_id).equalTo("quote.product_id", quote_id).equalTo("product.product_id", "quotes.itemkey").findAll()
  </code></pre>