Hi Everyone, Hope you are doing well, Today we are going to see how we can fetch data from LIST B based on LIST A item value. Following is use case: List A, It's a list employee with employee ID List B, It's a list of some external system which have list of data fetched on List A employee ID. List C, This list will be a combination of List A and List B data. We are going to use one loop in XSLT and for every employee ID we will fetch data from List B with out any nested loop. <?xml version="1.0" encoding="UTF-8" ?> <xsl:stylesheet version="1.0"> <xsl:param name="List2.outputPart"/> <xsl:param name="GetEmployee_ManagerId_OutputVariable.outputPart"/> <xsl:template match="/"> <ns0:ListData3> <xsl:for-each select="/ns0:PsftIdmEmpContractorsCollection/ns0:PsftIdmEmpContractors"> <xsl:variable name="EmpID"