SELECT
COL.CollectionID,
COL.Name,
COL.Comment,
MW.Name,
MW.Description,
MW.StartTime,
MW.Duration,
MW.UseGMTTimes
FROM
dbo.v_Collection COL,
dbo.vSMS_ServiceWindow MW
WHERE
COL.CollID = MW.CollectionID