hi! i'm not able to come up with a way to express the following postgresql query with sqlalchemy:
SELECT users.username, roles.role FROM ( SELECT * FROM users ORDER BY username LIMIT 2 ) AS users LEFT JOIN roles ON users.username = roles.username; i hope someone can help me out here :) what i want to achieve (and what the postgresql query does): i have to tables one with users one with all the roles of an user. and i want to get 2 users but with all the roles they have. thanks in advance! sifu ps: sqlalchemy is awesome! the only limiting factor seems to be my stupidity :) ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 _______________________________________________ Sqlalchemy-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
