How do I query and display Authors and their respective books

[Moiz Nagpurwala]

Hello,

I have 2 tables in my database, one for Author and another for Book.

I want to display all Author names as H2 and below each Author I want to display the books for that Author.

Please suggest the query and html view code for above scenario.

Thanks and regards.

[Clemens]

Hello,

all you need to know (including examples) is described here:
http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#One-to-many-relation

[Sh. Moiz Sh. Husain Bhai Nagpurwala]

Thanks for the reply. 

It addresses my question. 

Thanks and Regards. 

--
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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/-cmZSHG2vMM/unsubscribe.
To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/130043d0-2147-45ca-8e4f-39b276026e8bn%40googlegroups.com.