Same computer with in given two collections to create new collection:--

Same computer with in given two collections to create new collection:--

SELECT     dbo._RES_COLL_A01000EE.Name, dbo._RES_COLL_A01000EF.Name AS Expr1
FROM         dbo._RES_COLL_A01000EE FULL OUTER JOIN
                      dbo._RES_COLL_A01000EF ON dbo._RES_COLL_A01000EE.MachineID = dbo._RES_COLL_A01000EF.MachineID
WHERE     (NOT (dbo._RES_COLL_A01000EF.Name IS NULL)) AND (NOT (dbo._RES_COLL_A01000EE.Name IS NULL))

--
----------------
Thanks
----------------