List all employee's names and their managers by manager name using an join
DROP TABLE Employees GO -- STEP 1 CREATE A TABLE NAME AS Employees WITH THREE FIELDS EmpId,EmpName,MgrId CREATE TABLE Employees ( EmpId INT NOT NULL ,EmpName VARCHAR (50) DEFAULT NULL ,MgrId INT DEFAULT NULL , PRIMARY KEY (EmpId) ) -- STEP 2 INSERT INTO VALUES Employees WITH THREE FIELDS EmpId,EmpName,MgrId INSERT INTO Employees ( EmpId ,EmpName ,MgrId ) VALUES ( 1 , 'Manoj' , NULL ); INSERT INTO Employees ( EmpId ,EmpName ,MgrId ) VALUES ( 2 , 'Yogesh' ,1 ); INSERT INTO Employees ( EmpId ,EmpName ,MgrId ) VALUES ( 3 , 'Ajay' , '2' ); INSERT INTO Employees ( EmpId ,EmpName ,MgrId ) VALUES ( 4 , 'Vijay' , '3' ); INSERT INTO Employees ( EmpId ,EmpName ,MgrId ) VALUES ( 5 , 'Vinay' , '4' ); INSE...