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
—————-

 

Leave a Reply

Your email address will not be published. Required fields are marked *