[sqlalchemy] How can I do an eager loading when joining multiple tables?

Hi list, I defined two tables, Users, Orders and Items, where Orders has a foreign key user_id depending on User.id and Items has a foreign key order_id on Order.id. I'd like to do eager loading when joining these three tables by: session.query(Users).join(Users.orders,

Re: [sqlalchemy] How can I do an eager loading when joining multiple tables?

On Jan 24, 2011, at 5:54 AM, Joel Zhou wrote: Hi list, I defined two tables, Users, Orders and Items, where Orders has a foreign key user_id depending on User.id and Items has a foreign key order_id on Order.id. I'd like to do eager loading when joining these three tables by: