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-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 web2py+unsubscr...@googlegroups.com. 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 web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/CAKC%3DaX7WPgAYJdcdU9CaJvQfRWCRgutWzezW8gFh32xkjGAGkQ%40mail.gmail.com.
