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.