Query from RDBMS Event generator

This is what I would like to do.

I want the Integration process to kick in as soon as a new row in a table called tableA is added. For this I have defined the channel rule in the RDBMS Event Generator.

So as soon as new row is added , I want to get the result of the query "Select * from tableB where id=1"  and send it to the subscription method in my jpd.

How do I do this?

thanks in advance