I wan to write the query for following output

See more:

C#

EMP Table AS Follows;

EMPID  EMPNAME  MGRNo   MGRNAME
 1     Raj      Null     RAvi
 2     Ram       1       Sam
 3     Hari      2       Yogi

from the above EMP Table i wan the output as follows;

I want the output

EMPID  EMPNAME  MGRNAME
 1     Raj       RAvi
 2     Ram       Sam   
 3     Hari      Yogi

For that how to write the query.

[edit]Code block added - OriginalGriff[/edit]