 <p>Assuming that <code>tbl_b.col_ba</code> is a primary key (or just unique field) simple <code>JOIN</code> should help. Try this SQL:</p> <pre><code>SELECT col_aa, col_ab FROM tbl_a JOIN ( SELECT col_ba FROM tbl_b WHERE col_bb IN ( SELECT col_ca FROM tbl_c WHERE col_cb = 1 ) ) T2 ON (col_ac = T2.col_ba AND col_ad = T2.col_ba) </code></pre> <p>Hope it will help</p>