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

by

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 Comment