[sqlalchemy] Alias for a joined column name

I'm doing something like this where each Item has 2 ForeignKeys to Dealer for buyer and seller: seller = dealers.alias('seller') buyer = dealers.alias('buyer') engine.execute(select([items, seller.c.name, buyer.c.name]).fetchall() When I do this the seller and buyer name end up in the

Re: [sqlalchemy] Alias for a joined column name

On 8/16/2010 5:12 PM, Conor wrote: On 08/16/2010 04:47 PM, Michael Hipp wrote: I'm doing something like this where each Item has 2 ForeignKeys to Dealer for buyer and seller: seller = dealers.alias('seller') buyer = dealers.alias('buyer') engine.execute(select([items, seller.c.name,