Most likely another newbie question, but how do I resolve an
ambiguous column name that
is present in two tables after a joing?
For example, SQL lets me address the ambiguous column just by
prefixing the table name.
SELECT table1.colum, table2.column
FROM table1
INNER JOIN table2 on table2.id = table1.id
However, if I perform the following query in SQL alchemy, I can only
access by column name.
Trying to access row['table1.column'] results in a KeyError exception.
query = select[table1, table2], from_obj=[
table1.join(
table2, table2.c.id == table1.c.id
)
results = query.execute()
for row in results.fetchall():
print row.column
How can I access both table1 and table2's column value from the same row object?
-------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
