hmm...
I am trying your select and it now generates the same sql as the old
dal. please try this:
Domain = db.domain
Client = db.client
Manager = db.contact.with_alias('manager')
sql = db(Domain.id==1)._select(
Domain.ALL, Client.ALL,Manager.ALL,
left=[Client.on(Client.id==Domain.client_id),
Manager.on(Manager.id==Client.manager_id)])
print sql
what do you get?
I get
SELECT domain.id, domain.name, domain.client_id, client.id,
client.name, client.manager_id, manager.id, manager.name FROM domain
LEFT JOIN client ON (client.id = domain.client_id) LEFT JOIN contact
AS manager ON (manager.id = client.manager_id) WHERE (domain.id = 1);
On Dec 21, 2:55 pm, HaM <[email protected]> wrote:
> I just tried with the last revision (1414:da25156addab) and the
> problem stills the same.
