I figured it out. Thank you.
ionel On Jan 11, 3:30 pm, ionel <[email protected]> wrote: > Thank you massimo for your prompt response. > > I didn't very well explained my problem. > > I have 3 tables: category, subcategory, subsubcategory > > subcategory references category > subsubcategory references subcategory > > Have you en example for this. > > Thank you > > On Jan 11, 3:02 pm, mdipierro <[email protected]> wrote: > > > Here are two examples: > > 1) > > > db.define_table('a',db.Field('name')) > > db.define_table('b',db.Field('name')) > > db.define_table('t',db.Field('name'),db.Field('aid',db.a),db.Field > > ('bid',db.b)) > > rows=db().select(db.t.name,db.a.name,db.b.name,left=[db.a.on > > (db.a.id==db.t.aid),db.b.on(db.b.id==db.t.bid)]) > > > 2) > > db.define_table('a',db.Field('name')) > > db.define_table('t',db.Field('name'),db.Field('aid',db.a),db.Field > > ('bid',db.a)) > > rows=db().select(db.t.name,db.a.name,db.a.with_alias('b').name,left= > > [db.a.on(db.a.id==db.t.aid),db.a.with_alias('b').on > > (db.a.id==db.t.bid)]) > > > On Jan 11, 1:24 pm, ionel <[email protected]> wrote: > > > > Hello, > > > > Do anybody knows how to implement LEFT OUTER JOIN with 3 tables in > > > web2py? > > > > I saw the example with 2 tables in massimo's book, but I can't figure > > > out how to implement it with 3 tables. > > > > Thank you > > > > ionel > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
