on 03-25-2010 5:14 AM
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
Go thru this - http://www.w3schools.com/SQl/sql_join_inner.asp
raj.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Emmanuel, so basically you are looking for a SQL query to achieve the same?
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.