Seperate Email id, for employee and manager

[Raghuvir]

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

[MFGF]

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.

[Raghuvir]

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

[MFGF]

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.