Hi Simon.
I did indeed get it working in the end. I did not know about isOuter=True.
- That's a new one. I used the .outerjoin and was able to chain join
followed by multiple outerjoins.
Many thanks once again for extra titbits of info. Much appreciated.
Regards, Jeremy
On Friday, 9 February 201
As you say, .join() produces an inner join by default. You can specify
isouter=True to get a left outer join (or call the .outerjoin method
instead), and full=True to get a full outer join. I think you'd get a
cross join if you just didn't call the .join() method at all.
Simon
On Fri, Feb 9, 2018
I'm wondering if this is part of the secret sauce:
http://docs.sqlalchemy.org/en/latest/orm/query.html#sqlalchemy.orm.join
Also I guess cross-join may be another join type.
JOIN is INNER by default..
https://stackoverflow.com/a/19646594/495157
On Friday, 9 February 2018 16:03:03 UTC, Jeremy Flow