SELECT COL.CollectionID, COL.Name, COL.Comment, CTSC.parentCollectionIDFROM dbo.v_Collection COL, dbo.v_CollectToSubCollect CTSCWHERE CTSC.subCollectionID = COL.CollectionID