title: What's the proper way to write a Model->find() in CakePhp across three tables?
body: <p>can anyone tell me what is the best way to do something like, from a db as</p>
  
  <pre><code>Table 1
  -id
  -data
  -foreign_key_id_table2
  
  Table 2
  -id
  -data
  -foreign_key_id_table3
  
  Table 3
  -id
  -data
  </code></pre>
  
  <p>I need to select all items of table one linked to all items in table 2 of a given table 3 entry
  something like</p>
  
  <pre><code>select table1.data from table1 where table1.foreign_key_id_table2 in (select table2.id from table2 where table2.foreign_key_id_table3 = X)
  </code></pre>
  
  <p>but i need to do that with cakephp and as i'm new with it i can't figure out how</p>
  
  <p>please help :)</p>