[sqlalchemy] Re: sql syntax for outerjoin in 0.3.7

2009-08-18 Thread vindhyavasini
i know if i use later versions my problem will be easily solved but upgrading to newer version might screw some parts of project, that i will have to check and will be a bit bothersome task. please suggest me something to make it work with this version only. On Aug 17, 11:19 pm, Philip Jenvey wr

[sqlalchemy] Re: sql syntax for outerjoin in 0.3.7

2009-08-18 Thread vindhyavasini
thanx a lot philip... i know i am using outerjoin on ORM query, but i couln't find doc about outjoin in ORM query so i sent link to SQL Expression language outerjoin i have tried a query also using outerjoin in select from_obj, in 2nd query that is [i think it is not ORM query is it?? i m a bit no

[sqlalchemy] Re: sql syntax for outerjoin in 0.3.7

2009-08-17 Thread Philip Jenvey
On Aug 17, 2009, at 2:48 AM, vindhyavasini wrote: > > hi all, > i am working on an open source project (http://project.askspree.de/) > i need to write this simple sql : > > SELECT tg_user.websites_specified AS tg_user_websites_specified, > tg_user.display_name AS tg_user_display_name, tg_user.c