Sorry no. On Nov 26, 6:42 am, Yannick <ytchatch...@gmail.com> wrote: > 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.
