Help with query [message #287447] |
Wed, 12 December 2007 04:45  |
aboodlardy
Messages: 80 Registered: November 2006 Location: India
|
Member |
|
|
Hi experts,
I have two tables
1.emp
2.sup (supervisor)
SQL> desc emp
Name Null? Type
----------------------------------------- -------- ---------------------
PERSON_ID NOT NULL VARCHAR2(23)
FIRST_NAME VARCHAR2(23)
EMAIL VARCHAR2(20)
SQL> desc sup
Name Null? Type
----------------------------------------- -------- ---------------------
PERSON_ID VARCHAR2(23)
SUP_ID NOT NULL VARCHAR2(23)
SQL>
the relation between these two is sup have person_id as foreign in emp. Person_id is the primary key in emp.
and these two have data as follows
SQL> select * from emp;
PERSON_ID FIRST_NAME EMAIL
----------------------- ----------------------- -----------------
1 a a@aecl
2 b b@aecl
3 c c@aecl
4 d d@aecl
SQL> select * from sup;
PERSON_ID SUP_ID
----------------------- --------------------
1 2
3 4
I want a query for this result.
First_name, Supervisoremail, person_id, supervisor_id, empemail, supervisor_name.
Please help
[Updated on: Wed, 12 December 2007 04:46] Report message to a moderator
|
|
|
|
|
|