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. On Nov 25, 9:00 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > 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))) > > On Nov 24, 10:26 pm, Yannick <ytchatch...@gmail.com> wrote: > > > 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. -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
