JDBC - Table join

Hi All,

I need to configure a sender JDBC adapter which needs to pull data from 2 tables. I need all the fields of both the tables. Say my first table contains field1, field2 andmy second table contains field3 and field 4. For this scenario how can I develop a data type? Also can I use a select querry which pulls data from 2 tables?

Thanks & Regards,

Jai Shankar.