擅长:python、mysql、java
<p>尝试:</p>
<pre><code>SalesManager.query \
.join(Branch) \
.join(Customer) \
.filter(SalesManager.id == 123)
</code></pre>
<p>您可能需要通过<code>join</code>的第二个参数提供显式的<code>on</code>参数,或者可能需要显式地在中添加映射表,但在这两种情况下,您要做的是:</p>
<pre><code>SELECT SM.*
FROM sales_manager SM
JOIN sales_manager_branches SMB
ON SM.id = SMB.sales_manager_id
JOIN branch B
ON SMB.branch_id = B.id
JOIN customer C
ON B.id = C.statemented_branch_id
WHERE -- Conditions go here
</code></pre>