Please check this code
DECLARE @Employee TABLE
(
ID int,
ID1 int,
Name nvarchar(10)
)
INSERT INTO @Employee VALUES(1,1,'Sek')
INSERT INTO @Employee VALUES(2,2,'Ram')
DECLARE @Dept TABLE
(
ID int,
[Description] nvarchar(10),
Mobile int
)
INSERT INTO @Dept VALUES(1,'Chenn',1234567891)
INSERT INTO @Dept VALUES(2,'Ramm',1234567891)
DECLARE @Mail TABLE
(
ID1 int,
[Address] nvarchar(10)
)
INSERT INTO @Mail VALUES(1,'kovil')
INSERT INTO @Mail VALUES(2,'stree')
Select e.Name,t.description,t.mobile ,m.address
FROM @employee e
LEFT OUTER JOIN @Dept t on e.id=t.id
LEFT OUTER JOIN @Mail m on m.id1=e.id1