hi all,
we have a table which are having fields
EMPL_ID
MGR_ID
EMAIL
what i want to do here is seperate the email for employee and manager, is this possible ?
Any suggestions ?
Regards
Quote from: Raghuvir on 11 Jul 2014 04:56:56 AM
hi all,
we have a table which are having fields
EMPL_ID
MGR_ID
EMAIL
what i want to do here is seperate the email for employee and manager, is this possible ?
Any suggestions ?
Regards
To whom does the email address on a row belong - the employee or the manager?
MF.
Hi MFGF,
it belongs to the EMPL_ID, i have joined another table to get the manager information i.e the MGR_ID.
is my requirement feasible ?
Regards
Quote from: Raghuvir on 11 Jul 2014 07:36:10 AM
Hi MFGF,
it belongs to the EMPL_ID, i have joined another table to get the manager information i.e the MGR_ID.
is my requirement feasible ?
Regards
So you have the Employee ID, the Employee Email and the Manager ID? Now you want to see the Manager Email? Is that your requirement?
If so, create an alias of the Employee table (called Manager) and join Manager ID of the Employee table to Employee ID of the Manager table.
You can get the email of the manager from this.
Cheers!
MF.