CREATE TABLE TableX(EMPID Int, EMPName Varchar(256), Dept Varchar(256)), Add Varchar(256)))
GO
CREATE TABLE TableY(EMPID Int, EMPName Varchar(256), Dept Varchar(256)), Add Varchar(256)))
GO
CREATE TABLE MasterXY(EMPID Int, EMPName Varchar(256), Dept Varchar(256)), Add Varchar(256)))
GO
INSERT INTO TableX VALUES(1,'Bagesh','IT','Pune')
INSERT INTO TableX VALUES(2,'Rajesh','IT','Pune')
INSERT INTO TableX VALUES(3,'Ganesh','Non IT','Chennai')
INSERT INTO TableX VALUES(4,'Dinesh','Non IT','Patna')
INSERT INTO TableY VALUES(1,'Bagesh','IT','Pune')
INSERT INTO TableY VALUES(2,'Rajesh','IT','Pune')
INSERT INTO TableY VALUES(3,'Ganesh','Non IT','Mumbai')
INSERT INTO TableY VALUES(4,'Dinesh','IT','Patna')
INSERT INTO MasterXY
SELECT * FROM TableX X INNER JOIN TableY Y
ON X.EMPID=Y.EMPID
AND x.EMPName=Y.EMPName
AND X.Dept=y.Dept
AND X.Add=Y.Add
select * from MasterXY