RE: [sqlalchemy] (OperationalError) (1066, "Not unique table/alias: '...'") when selecting only from a joined table

2011-06-29 Thread King Simon-NFHD78
Michael Bayer wrote > On Jun 28, 2011, at 1:31 PM, King Simon-NFHD78 wrote: > > > > FWIW, I *really* appreciate that you keep the old versions of the > docs > > around - I have an application that I maintain using SA 0.3, and > just > > last week I needed to refer back to the docs. I hope they neve

Re: [sqlalchemy] (OperationalError) (1066, "Not unique table/alias: '...'") when selecting only from a joined table

2011-06-28 Thread Michael Bayer
On Jun 28, 2011, at 1:31 PM, King Simon-NFHD78 wrote: > Michael Bayer wrote: >> - I am loathe to reference the 0.5 docs as people keep finding them >> and thinking they are current, but an example of this is at >> http://www.sqlalchemy.org/docs/05/ormtutorial.html#querying-with- >> joins >> >> (

RE: [sqlalchemy] (OperationalError) (1066, "Not unique table/alias: '...'") when selecting only from a joined table

2011-06-28 Thread King Simon-NFHD78
Michael Bayer wrote: > - I am loathe to reference the 0.5 docs as people keep finding them > and thinking they are current, but an example of this is at > http://www.sqlalchemy.org/docs/05/ormtutorial.html#querying-with- > joins > > (Note to people reading this: these are the *OLD DOCS* regarding

Re: [sqlalchemy] (OperationalError) (1066, "Not unique table/alias: '...'") when selecting only from a joined table

2011-06-28 Thread Michael Bayer
On Jun 28, 2011, at 12:26 PM, Oliver wrote: > I want to have the following query in sqlalchemy: > > SELECT t_objects_1.tid AS t_objects_1_tid FROM t_objects AS > t_objects_2 INNER JOIN c_objects AS c_objects_1 ON t_objects_2.tid = > c_objects_1.tid INNER JOIN t_objects AS t_objects_1 ON t_object

[sqlalchemy] (OperationalError) (1066, "Not unique table/alias: '...'") when selecting only from a joined table

2011-06-28 Thread Oliver
I want to have the following query in sqlalchemy: SELECT t_objects_1.tid AS t_objects_1_tid FROM t_objects AS t_objects_2 INNER JOIN c_objects AS c_objects_1 ON t_objects_2.tid = c_objects_1.tid INNER JOIN t_objects AS t_objects_1 ON t_objects_1.tid = t_objects_2.parent_id WHERE c.id = 1; this wo