diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2014-01-22 21:42:56 -0500 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2014-01-22 21:42:56 -0500 |
| commit | 7b90923eb1fe63384db6b463a152def07a4d0299 (patch) | |
| tree | 4fad989d93efd9ee6fae99bb0ca7f4ccdd9fd9ee | |
| parent | 743ceb045e8be8b606198f4d5c02a72abebb2fbb (diff) | |
| download | sqlalchemy-7b90923eb1fe63384db6b463a152def07a4d0299.tar.gz | |
used the wrong join
| -rw-r--r-- | doc/build/orm/relationships.rst | 7 |
1 files changed, 2 insertions, 5 deletions
diff --git a/doc/build/orm/relationships.rst b/doc/build/orm/relationships.rst index cdff64064..98a6e1bec 100644 --- a/doc/build/orm/relationships.rst +++ b/doc/build/orm/relationships.rst @@ -1301,11 +1301,8 @@ additional columns when we query; these can be ignored: sess.query(A).join(A.b).all() - {opensql}SELECT a.id AS a_id, a.b_id AS a_b_id, d_1.id AS d_1_id, - b_1.id AS b_1_id, d_1.b_id AS d_1_b_id, d_1.c_id AS d_1_c_id, - c_1.id AS c_1_id, c_1.a_id AS c_1_a_id - FROM a LEFT OUTER JOIN (b AS b_1 JOIN d AS d_1 ON d_1.b_id = b_1.id - JOIN c AS c_1 ON c_1.id = d_1.c_id) ON a.b_id = b_1.id + {opensql}SELECT a.id AS a_id, a.b_id AS a_b_id + FROM a JOIN (b JOIN d ON d.b_id = b.id JOIN c ON c.id = d.c_id) ON a.b_id = b.id Building Query-Enabled Properties |