Re: [Sqlalchemy-users] join with identical column names

2006-07-07 Thread Michael Bayer
youd have to do a select() with use_labels = True, or a select() where you name out each column with a label() function, i.e.:select ([a.c.col1.label('a_col1') ...])On Jul 5, 2006, at 3:16 PM, Jonathan Ellis wrote:If you're creating a Join on table A and table B, each of which has a PK "id" column,

Re: [Sqlalchemy-users] join with identical column names

2006-07-05 Thread Dennis Muhlestein
Hi Jonathan, I've used label: select([a.c.id.label('a_id') , b.c.id.label('b_id')], fromobj=[a.join(b)]) to do that a couple times. -Dennis On 7/5/06, Jonathan Ellis <[EMAIL PROTECTED]> wrote: > If you're creating a Join on table A and table B, each of which has a PK > "id" column, is there a wa

[Sqlalchemy-users] join with identical column names

2006-07-05 Thread Jonathan Ellis
If you're creating a Join on table A and table B, each of which has a PK "id" column, is there a way to disambiguate these in the join or mapper?  I.e., I want to be able to determine the value of both a.id and b.id, but not join on that column.-- Jonathan Ellishttp://spyced.blogspot.com Using Tom