SELECT c.OwnerID, c.OwnerType, c.CampaignID, c.Title AS CampaignTitle, s.OwnerID, s.skuId, p.ProductCode, p.unitvalue FROM tbl_CRO_Campaigns c, tbl_CRO_CampaignProducts p INNER JOIN tbl_PRD_SKUs s ON p.ProductCode = s.sku AND s.FSL_TableCode = 'MFR' WHERE c.OwnerType = 'MFR' AND c.startDate < #CreateODBCDate(Now())# AND c.endDate > #CreateODBCDate(Now())# AND c.CampaignID = p.campaignid AND p.ProductLevel = 'SKU'