Select
FCM.CollectionID,
C.Name
from
dbo.v_Collection c
join dbo.v_FullCollectionMembership FCM on C.CollectionID = FCM.CollectionID
Where
FCM.Name = ‘HPPC’