Article:  |
The Outer Limits of SQL JOINs | |
| Subject: | Query | |
| Date: | 2006-02-16 12:33:57 | |
| From: | ShaktiArora | |
|
Hi,i have a problem in outer join statements. i am trying to use OR clause with outer join and not getting a required result.what would be the correct answer for the following question My question is: Display the last name, job id, department id, and department name for all employees who do not work in department 110. The result will include any employee whose department id does not exist in the department table.
|
||
