select * from qmd_territories where territoryid in () select marketingactivityname, marketingactivityid from tbl_CRM_MarketingActivities ma where ownerid = and ownertype = and ma.publishdate <= getdate() and ma.unpublishdate >= getdate() order by marketingactivityname
Sales Call Search
Current Filters: