Return field value based on the same table

[snoopy2003]

Hello,



This must be simple but I do not find a way to solve it.

I have table worker:
workerID
workerName
workerManager

workerManager is one of the workerID numbers.
I wish to retrieve workerName based on workerManager value
(look in the same table for a worker with workerID=workerManager)

How can I do it ?

Thank you for your help

[Rixxe]

From what you have said, I think what you need is a Self Join:

SELECT workerName FROM table_worker AS A
INNER JOIN table_worker AS B
ON A.workerID = B.workerManager
WHERE B.workerManager = 'value'

If thats incorrect have a go at changing it yourself to suit your needs

[snoopy2003]

Hello,

Thank you for your help.
I am going to test it in my DB.

Thank you