On 30 mar, 04:17, weheh <richard_gor...@verizon.net> wrote: > You need a left outer join. Here are a couple of examples that I think > should work (caveat: I didn't test them): ... > #way2 > qry1=(db.t1.f12==10) > leftjoin=db.t2.on(db.t2.f22==db.t1.id) > rows=db(qry1).select(db.t2.ALL,left=leftjoin)
Yes, that's what I did, I used left join. This is what we would use them if the query would have made with pure sql. Knowing that I can do the following: row = db.t2[n] print row.f22.f11 print row.f22.f12 DAL thought would solve the query in the same way. Thank you. Jose -- 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.