KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I want to query a junction table for the value of column aID that matches all values of a list of ids ids=[3,5] in column bID . This is my junction table ( JT ): aID bID 1 1 1 2 2 5 2 3 1 3 3 5 I have this query: session.query(JT.aID).filter(JT.bID.in_(ids)).all() This query returns the aID values 1 , 2 and 3 because they all have rows with either 3 or 5 in the bID column. What I want the query to return is 2 because that is the only aID value that has all values of the ids list in its bID column. Don't know how to explain the problem better, but how can I get to the result?
Tags (comma-separated)
Save Edits
Cancel