[sqlalchemy] Re: subquery and inheritance

2008-04-19 Thread Michael Bayer
On Apr 18, 2008, at 10:42 PM, kris wrote: select * from nodes, (select node2_id as id2 from assoc, (select node2_id as id1 from assoc where relation = 'is-a' and node1_id = 100) as isa where relation

[sqlalchemy] Re: subquery and inheritance

2008-04-19 Thread Michael Bayer
On Apr 18, 2008, at 3:18 PM, kris wrote: select item.id from item, (select dataset_me.something_id from (select * from base, dataset where base.id = dataset.id and base.owner=me) as dataset_me where