unable to create a service that would pull the data from form data modal



Hello - I have a created a form data model by joining(one to many) two MySQL tables(table1 and table2) in AEM 6.3. I was able to fetch data(two tables) by testing it’s form data model but not through a service. Looks like a service is capable of fetchInd data from one table but not after joining two tables. When I call the service after joining two tables i am getting table1’s data alone.

So wondering if i am missing something.