I am trying to add two queries in Pentaho Report Designer so that I could get query results from more than one table.
Here is my case:
There are two possible way of reading two queries in PRD.
Creating a SUB-REPORT and then define the second query. Check this wiki for more.
JOINING the two tables inside a single query, as correctly said by Kotukunui.