Women in Technology

Hear us Roar



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.


please reply me as soon as you can because i have my exam tomorrow.
thankyou.
Regards,
Shakti Arora