[sqlalchemy] Re: Left join or subselect syntax(more than one filter on join key)

,vcc_schema.RoleElementsTable.isActive== 'Y')) query_stmt = select([vcc_schema.RolesTable.c.roleId,vcc_schema.RolesTable.c.name, vcc_schema.RolesTable.c.description], not_(vcc_schema.RolesTable.c.roleId.in_(subquery_stmt))) Hope it will help others like me.. On Jun 4, 9:14 am, aruna-cgx [EMAIL PROTECTED] wrote

[sqlalchemy] Left join or subselect syntax(more than one filter on join key)

SQL query for left join which give my desire result is as follow. i can use left join or sub select, though I prefer to use left join but I am Ok with subselect also. I don't know how to write this query in sqlalchemy. I refered document, but my query differes on join key as I have more than

[sqlalchemy] need help for left join

Hello: I am new for SQLAlchemy and first time using with Plone. I need some help for left join. I have two tables, roles and roleElements. Structure and sample data for these two tables I am including for easy popup of table/data which will be useful to him\her who will try to help me.