Re: [web2py] Re: left outer join

[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'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  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, 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
> 
> .
>
>

-- 
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/CAHPvVMbQnqrwURpCXJ8r8yi3euDbZjLBtqVs_po0NSnvDP2vtw%40mail.gmail.com.

Re: [web2py] Re: left outer join

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

.

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

[web2py] Re: left outer join

[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
> 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.