Sql

[cesi]

Hi there,

I am new on this forum :-S

I have been working on SQL. Now I have a question to solve and explain to my boss how to get the result of the question. Can you please help me to find out how to solve this?

given question is,

There is only one table looks like

Eleman_Id Eleman_Ad Mudur_Id
5 Faruk SARI 20
10 Selma ACAR 35
15 Ali KUCUK 35
20 Mehmet CICEK 45
25 Fatma FIRAT 20
30 Ahmet AK 20
35 Emine GUVEN 45
40 Salim GUVEN 20
45 Veli INCE
50 Ayse OZ 35

I need the get the below result.

Mudur AD Eleman_Ad
Emine GUVEN Selma ACAR
Emine GUVEN Ali KUCUK
Emine GUVEN Ayse OZ
Mehmet CICEK Faruk SARI
Mehmet CICEK Fatma FIRAT
Mehmet CICEK Ahmet AK
Mehmet CICEK Salim GUVEN
Veli INCE Mehmet CICEK
Veli INCE Emine GUVEN
YOK Veli INCE

Thanks in advance

[Fumigator]

You want to JOIN the table with itself.