select v_FullCollectionMembership.CollectionID, v_Collection.Name
from v_FullCollectionMembership
join v_Collection ON v_FullCollectionMembership.CollectionID = v_Collection.CollectionID
where v_FullCollectionMembership.Name = ‘machinename’