sql query to find packages that are not being advertised
select * from v_package where packageid not in (select PackageID from v_AdvertisementInfo)
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
select * from v_package where packageid not in (select PackageID from v_AdvertisementInfo)