[sqlalchemy] Re: Multi table select?

2009-11-04 Thread AF
On Oct 27, 8:03 am, Mike Conley mconl...@gmail.com wrote: On Mon, Oct 26, 2009 at 10:09 PM, Bobby Impollonia bob...@gmail.com wrote: Let's say you have 2 mapped classes class Stuff1(Base):      --- etc. class Stuff2(Base)      --- etc. You can do something like this q1 =

[sqlalchemy] Re: Multi table select?

2009-10-27 Thread Mike Conley
On Mon, Oct 26, 2009 at 10:09 PM, Bobby Impollonia bob...@gmail.com wrote: You can also create a view mapped to that union and use that as a virtual table so that you don't have to repeat the union specification for every query: http://www.w3schools.com/Sql/sql_view.asp I don't know if

[sqlalchemy] Re: Multi table select?

2009-10-26 Thread AF
On Oct 26, 8:48 pm, AF allen.fow...@yahoo.com wrote: Hello, I don't know if this is even possible is SQL, so please bear with me :) There are a couple a tables (say, a b) that are used as logs for two different processes.   They both have the same simple structure. (id, time_stamp,

[sqlalchemy] Re: Multi table select?

2009-10-26 Thread Bobby Impollonia
You can also create a view mapped to that union and use that as a virtual table so that you don't have to repeat the union specification for every query: http://www.w3schools.com/Sql/sql_view.asp I don't know if that helps for SQLAlchemy though. On Mon, Oct 26, 2009 at 5:59 PM, AF