SELECT
vSMS_AdvertisementInfo.AdvertisementID as ‘Advert Id’,
vSMS_AdvertisementInfo.AdvertisementName as ‘Advert Name’,
vSMS_AdvertisementInfo.ProgramName as ‘Program’,
vSMS_AdvertisementInfo.PackageName as ‘Pacakge’,
vSMS_AdvertisementInfo.CollectionName as ‘Collection’
FROM
vSMS_AdvertisementInfo vSMS_AdvertisementInfo