Re: [web2py] Re: left outer join

2022-02-20 Thread Jonathan Clark
Hi, Sorry I hadn't noticed that was what you meant. I was just trying to say that the book has a section on left joins, like many other topics, which you might not have seen. It's a long time since I looked at this, but I thought you could treat a select as a table for this kind of thing, but I'v

Re: [web2py] Re: left outer join

2022-02-20 Thread Al Ex
Thank you But what if the left join is made on an arbitrary select, not an already defined table? Maybe I am missing something evident On February 20, 2022 at 18:15:50, jonatha...@whatho.net ( jonathan.cl...@whatho.net) wrote: http://www.web2py.com/books/default/chapter/29/06/the-database-abs

[web2py] Re: left outer join

2022-02-20 Thread jonatha...@whatho.net
http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Left-outer-join On Saturday, 19 February 2022 at 02:48:35 UTC alex wrote: > Hi, > > How can I reproduce this LEFT OUTER JOIN in PyDAL ? > > > SELECT name > FROM doc > > LEFT JOIN ( > > SELECT name >