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've never done it. So I'll leave this for more knowledgeable people to answer. Best wishes. On Sun, 20 Feb 2022 at 11:33, Al Ex <[email protected]> wrote: > 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, [email protected] ( > [email protected]) wrote: > > > 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 >> FROM X >> INNER JOIN ... >> WHERE ... >> ) T ON ( T.name = name) >> >> WHERE >> T.name IS NULL >> >> >> -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/web2py/3e47a5ea-6048-4ea6-a376-b150083a7c31n%40googlegroups.com > <https://groups.google.com/d/msgid/web2py/3e47a5ea-6048-4ea6-a376-b150083a7c31n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/CAHPvVMbQnqrwURpCXJ8r8yi3euDbZjLBtqVs_po0NSnvDP2vtw%40mail.gmail.com.
