cancel
Showing results for 
Search instead for 
Did you mean: 

Fetching an Inner Join on JDBC adapter

Former Member
0 Kudos

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.

Regards

Emmanuel

Accepted Solutions (0)

Answers (3)

Answers (3)

justin_santhanam
Active Contributor
0 Kudos
former_member208856
Active Contributor
0 Kudos

check this thread

In this thread, there are some links, check that also.

justin_santhanam
Active Contributor
0 Kudos

Emmanuel, so basically you are looking for a SQL query to achieve the same?

Thanks!