-
confused of solution to this query
in emp table ename column stores employees information and also managers information, so i want to query in the following output
mname empno ename
Blake 7499 Allen
7521 Ward
7900 James
7844 Turner
7654 Martin
Clark 7934 Miller
Ford 7369 Smith
Jones 7788 Scott
7902 Ford
so on the output should be generated
mname is manager name
ename is employee name
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|