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 web2py@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 -~----------~----~----~----~------~----~------~--~---