SELECT GroupDetails.GroupName, AgentInfo.AgentInfoID, AgentInfo.GroupID, AgentInfo.ImporterURLUsed, GroupDetails.Description
FROM AgentInfo INNER JOIN
GroupDetails ON AgentInfo.GroupID = GroupDetails.GroupID
WHERE (AgentInfo.ImporterURLUsed = N'https://sharpdevicecounters.nl/OneStopImporter/importer.asmx')