Home » RDBMS Server » Server Administration » wanna print emp name and manager under which he is working..
wanna print emp name and manager under which he is working.. [message #374190] Wed, 30 May 2001 01:23 Go to next message
sweta
Messages: 19
Registered: May 2001
Junior Member
EMPNO ENAME JOB MGR
------ ---------- --------- ---------
7369 SMITH CLERK 7902
7499 ALLEN SALESMAN 7698
7521 WARD SALESMAN 7698
7566 JONES MANAGER 7839
7654 MARTIN SALESMAN 7698
7698 BLAKE MANAGER 7839
7782 CLARK MANAGER 7839
7788 SCOTT ANALYST 7566
7839 KING PRESIDENT
7844 TURNER SALESMAN 7698
7876 ADAMS CLERK 7788
7900 JAMES CLERK 7698
7902 FORD ANALYST 7566
7934 MILLER CLERK 7782

how do i prin the emp no and name and managers name under which he is working....

Report message to a moderator

Re: wanna print emp name and manager under which he is working.. [message #374201 is a reply to message #374190] Wed, 30 May 2001 08:46 Go to previous message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi
select a.empno, a.ename, a.job, b.ename from emp a, emp b
where a.mgr = b.empno

Bala.

Report message to a moderator

Previous Topic: Using a Grant Sequence
Next Topic: wanna print emp name and manager under which he is working..
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 13:23:07 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.