Table structure:

A(id, name)
B(id, name, A_id)
C(id, name, B_id)

one-to-many A->B and B->C

I'm trying to use session.query() to select all rows of A such that
none of the joined B rows have any joined C rows.

A:
(1,'A1')
(2,'A2')

B:
(1,'B1',1)
(2,'B2',1)
(3,'B3',2)

C:
(1,'C1',1)

So, it would return (2,'A2'). Any help would be appreciated.

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.

Reply via email to