 <p>This should work for you:</p> <pre><code>SELECT * FROM E WHERE EXISTS ( SELECT 1 FROM A JOIN B ON A.B_key = B.B_key JOIN C ON B.C_key = C.C_key JOIN D ON C.D_key = D.D_key WHERE D.E_key = E.E_key AND A.A_key = ? ) </code></pre>