Skip to Content
Former Member
Mar 25, 2010 at 05:14 AM

Fetching an Inner Join on JDBC adapter


Hi Gurus

I have a requirement to get data from two tables (headers and details) on DB2. So I´m using an inner join on the sender JDBC adapter query.

The relationship between both tables is a package number. It can just have one header but can have multiple details.

I have to fetch the query to get only one package header with all the details associated. Do someone know how to do this?

Or how to limit an inner join?

Thanks in advanced.