Having problem to show Master and child table data
I have two table where in one table I have the book category and in another table I have the books name like as below
>>category table
==========
catID
Cat Name
>>books table
========
bookID
catid
bookName
My output need in a repeat region on the page like below;
-------------------------------------------------------
Cat Name A
- bookName1
- bookName 2
Cat Name B
- bookName 3
- bookName 4
I could not figure out how to do this join query so that in my final output I can show data like this, Pls help.