title: Python/SQLAlchemy - Need to convert an inner join query with 3 tables into Python
body: <p>I need some help converting this query into SQLAlchemy.</p>
  
  <pre><code>select field from table t1 join table t2 on t1.detail_id = t2.id join table t3 on t3.id = t2.rate_id where t2.name = 'fred' and t3.rate_type = 'Custom' and t3.description = 'Default';
  </code></pre>
  
  <p>I have been able to convert inner join queries with two tables, but need some help with this one.</p>
  
  <p>Appreciate your help.TIA.</p>