create table employee(empid int identity(1,1) primary key, empname varchar(50), empaddress varchar(50))
insert into employee(empname,empaddress) values('abcd','hyderabad')
insert into employee(empname,empaddress) values('efgh','pune')
insert into employee(empname,empaddress) values('ijkl','banglore')
insert into employee(empname,empaddress) values('mnop','gurgaon')
insert into employee(empname,empaddress) values('qrst','mumbai')

SELECT Participants.Node.value('@EmpID', 'INT') AS EmployeeID,
Participants.Node.value('@EmpName', 'VARCHAR(50)') AS EmployeeName,
emp.empaddress as EmployeeAddress
FROM 
@Participants.nodes('/ArrayOfEmployees /Employees ') Participants (Node) 
INNER JOIN employee emp on emp.empid = Participants.Node.value('@EmpID[1]', 'INT')

WITH EmpId (EmployeeId, EmployeeName)
AS
(SELECT Participants.Node.value('@EmpID', 'INT') AS EmployeeID,
Participants.Node.value('@EmpName', 'VARCHAR(50)') AS EmployeeName
FROM 
@Participants.nodes('/ArrayOfEmployees /Employees ') Participants (Node) )

SELECT EmpId.EmployeeId, EmpId.EmployeeName, Email, [Home Address]
FROM EmpId
INNER JOIN Employee EMP ON EmpId.EmployeeID = EMP .EmployeeID