Complex SQL Query - Left Out Join With A Third table...

[Yannick]

Hello mate,
Let's said for example I have the following:

rows = db().select(db.table_A.first_name, db.table_B.email,
db.table_B.ID,
left=db.table_B.on
( db.table_A.ID = db.table_B.FK) )

NOW I want to do another left OUTER JOIN of the table from <rows>
with a third table "table_C" on a condition "db.table_B.ID =
db.table_C.ID"
How can I do that ?


Thanks for your help,

Cheers,
Yannick P.

[mdipierro]

Yes.

left=(db.table_B.on(db.table_A.ID = db.table_B.FK)),
db.table_C.on(db.table_A.ID = db.table_C.FK)))

[Yannick]

Thanks Massimo,
I just wonder, I do know that is possible to see the SQL Query by
using _select()... I was wondering if there opposite operation ? Like
if is possible to write the SQL query and see DAL code of web2py ?

Thanks,
Yannick P.

[mdipierro]

Sorry no.