List of collection and their parent collection

SELECT
    COL.CollectionID,
    COL.Name,
    COL.Comment,
    CTSC.parentCollectionID
FROM
    dbo.v_Collection COL,
    dbo.v_CollectToSubCollect CTSC
WHERE
    CTSC.subCollectionID = COL.CollectionID