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