Compare 2 columns query HELP!
Posted by:
Phil Smith
Date: April 19, 2005 03:54PM
Hey All, I'm having problems with this Query. I have a DB that I'm writing a query through MS SQL enterprise Manager. Majorly simplfied here it is:
Table contains three columns, employeeid employeeLastName, supervisorid
Every employee has a supervisor assigned to them. That supervisor id is also located in the employeeid column, just in a different area, example:
employeeid: employeeLastName supervisorid
125263 Smith 125266
125266 Jones 124423
The end user wants to know the supervisor's last name not the id. Ive bunch of different things, but I am a newbie to sql. Basically I want to do something that says if supervisorid IN employeeid display supervisorid. Ive tried unions, a sub select statement, but I'm always off somewhat. I have access to do anything I want on the DB. Can someone point me in the right direction?
Subject
Written By
Posted
Compare 2 columns query HELP!
April 19, 2005 03:54PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.