擅长:python、mysql、java
<pre><code>session.query(User).join((Group, User.groups)) \
.join((Department, Group.departments)).filter(Department.name == 'R&D')
</code></pre>
<p>这也适用,但使用子选择:</p>
<pre><code>session.query(User).join((Group, User.groups)) \
.filter(Group.departments.any(Department.name == 'R&D'))
</code></pre>