[sqlalchemy] Lookup table referenced by multiple tables in parent query

2014-05-29 Thread Daniel Grace
I have a table structure something like this: * Two tables Foo and Bar * FooBar, an many-to-many association table between Foo and Bar * A County lookup table referenced by both Foo and Bar * A Region lookup table referenced by County I'm frequently running queries that involve both Foo and bar,

Re: [sqlalchemy] Lookup table referenced by multiple tables in parent query

2014-05-29 Thread Michael Bayer
On May 29, 2014, at 2:09 PM, Daniel Grace thisgenericn...@gmail.com wrote: I have a table structure something like this: * Two tables Foo and Bar * FooBar, an many-to-many association table between Foo and Bar * A County lookup table referenced by both Foo and Bar * A Region lookup table