You can do it with 
this https://groups.google.com/forum/#!topic/web2py/_xQUWYXZG54
but I leave it as an exercise how to do it. I will post an example later.

On Tuesday, 5 July 2016 13:10:19 UTC-5, Carlos Cesar Caballero wrote:
>
> Hi Antony, tough day with me no?
>
> You not need a join to get the id of any of the related tables, but if you 
> need only the top-table data, you only need one join, not n (you can look 
> the diagrams)
>
> Greetings.
>
>
> El 05/07/16 a las 11:33, Anthony escribió:
>
> On Tuesday, July 5, 2016 at 11:23:36 AM UTC-4, Carlos Cesar Caballero 
> wrote: 
>>
>> Hi Marlysson, thanks for your answer, yes maybe I must be more concise.
>>
>> In a clasic identifyng relationship, lets say a relation author-book-page 
>> (author has books and books has pages) In this case, the book primary key 
>> includes the author id, and the page primary key includes the book primary 
>> key (author and book ids).
>>
>> One of the advantages of the identifyng relationship model is that I can 
>> known what book belongs page without need a join, that can be useful when 
>> we have a deep relation tree.
>>
>
> Can you show an example of the table definitions that would allow you to 
> get the related data without a join?
>
> Anthony
> -- 
> 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.
> For more options, visit https://groups.google.com/d/optout.
>
>
>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Reply via email to