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 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 Ellis
> http://spyced.blogspot.com
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>
>
> _______________________________________________
> Sqlalchemy-users mailing list
> Sqlalchemy-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
>
>
>
--
You can see what's happening at http://muhlesteins.com
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
