我有以下SQL脚本。这非常简单,很不幸,只有确定显示哪些广告系列的where子句才起作用。
SELECT
a.id,
a.leadid,
a.campaign_name__c,
cast(a.firstrespondeddate as date),
b.status,
cast(b.createddate as date),
b.ownerid
FROM rjm_current.sf_campaignmember a
LEFT JOIN rjm_current.sf_lead b ON a.leadid = b.id
WHERE a.campaign_name__c LIKE '%demo%' OR a.campaign_name__c LIKE '%contact%'
AND cast(a.firstrespondeddate as date) <> '7/14/2015'
AND b.status = 'New'
AND a.contactid IS NULL
AND a.leadid IS NOT NULL
任何帮助,不胜感激。在另一个查询中,我不得不将firstrespondeddate
一个表中的date转换为日期,然后使用另一个表来表示,firstrespondeddate <> '7/15/2015'
但是它无需创建一堆表就可以工作。
OR
表达式应放在方括号中:
WHERE (a.campaign_name__c like '%demo%' OR a.campaign_name__c like '%contact%')
and cast(a.firstrespondeddate as date) <> '7/14/2015'
and b.status = 'New'
and a.contactid is null
and a.leadid is not null
请参阅运算符优先级
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句