SOAP to JDBC Sync

Hi,

My scenario is SOAP to JDBC sync.

we need to sending employe ID as a request from the web service, based on the employe id we need to populate(with Select statement) the data from two different tables one is header and another one is item table. How can i achieve this requirement? I have seen couple of blogs which is discussing about JDBC receiver as a sync with one table with select statement. But my requirement is need to get the response from more than one table with select command.

Thanks,

Sateesh