alias work only with left outer joins only.
On May 18, 9:40 am, Rohan <yourbuddyro...@gmail.com> wrote: > web2py: Version 1.92.1 (2011-02-16 15:04:40) > > with_alias fails to work when where clause is specified. It works fine when > documented example is run > > >>> db()._select(db.person.name, Father.name, Mother.name, > > left=(Father.on(Father.id==db.person.father_id), > Mother.on(Mother.id==db.person.mother_id))) > > 'SELECT person.name, father.name, mother.name FROM person LEFT JOIN person > AS father ON (father.id = person.father_id) LEFT JOIN person AS mother ON > (mother.id = person.mother_id);' > > but it fails where I specify a where clause > > >>> db((db.person.father_id == Father.id))._select(db.person.name, > > Father.name) > > SELECT person.name, father.name FROM person, father WHERE (person.father_id > = father.id); > > in second case, alias is not created. Read in a thread that with_alias > currently supports left outer join only. Any plan to extend its usage?