No :)
On Dec 27, 6:03 pm, mdipierro <[email protected]> wrote: > Did this work with the old dal? > > On Dec 27, 9:41 am, HaM <[email protected]> wrote: > > > Hi, > > > I'm trying to do INNER JOIN with aliased table and I'm experiencing > > problem. > > Here is my example: > > > Domain = db.domain > > Client = db.client > > Manager = db.contact.with_alias('manager') > > sql = db((Domain.id==1)& > > (Client.id==Domain.client_id)& > > (Manager.id==Client.manager_id))._select( > > Domain.name, Client.name, Manager.name) > > print sql > > > Result: > > SELECT domain.name, client.name, contact.name FROM domain, client, > > contact WHERE (((domain.id = 1) AND (client.id = domain.client_id)) > > AND (contact.id = client.manager_id)); > > > It works but it doesn't use the alias name for the table contact. Thus > > the resulting dict() doesn't contains the key "manager" but the key > > "contact". > > > Thanks again for your investigations. > >
