Hi Sharad,
You can do something like this:
SELECT EMP.No No,
SUP.Name SupName
FROM Employee.Employee EMP
LEFT JOIN EMP/Employee_Superior/Superior SUP
And if you want to get only the employees where superior is filled in you use INNER JOIN instead of LEFT JOIN
Kind regards,
Steven