nonequijoin
This is a discussion on nonequijoin within the DB2 forums, part of the Database Server Software category; --> HI, I just wondering if DB2 support nonequijoin... For example there are two tables one is Employees table, the ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 05:20 PM
| ||||
| ||||
 nonequijoin HI, I just wondering if DB2 support nonequijoin... For example there are two tables one is Employees table, the other is JOB_GRADES table EMPLOYEES JOB_GRADES Last Name Salary GRA LOWEST_SAL HIGHEST_SAL King 4000 A 1000 2999 Kachhar 7000 B 3000 5999 De Hann 5000 C 6000 9999 .... I want to get the last name, salary and grade from both table. How to write the query? any suggestion is very appreciated! Thanks.      |
|
02-26-2008, 05:22 PM
| ||||
| ||||
| Re: nonequijoin ak_tiredofspam@yahoo.com (AK) wrote in message news:<46e627da.0312071618.4d82d7b5@posting.google. com>... > SELECT LAST_NAME, SALARY, GRADE > FROM EMPLOYEE JOIN JOB_GRADE ON SALARY BETWEEN LOWEST_SAL AND HIGHEST_SAL HI, Thanks. |
 |
« ISERIES driver for AS400 return erroneous data for NULL Values
|
Database marked bad. One more time. »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 07:11 PM.
