SELECT SubscriberKey, COUNT(*) AS TotalSentLast180Days
FROM (
SELECT s.SubscriberKey
FROM ENT._Sent s
INNER JOIN ENT.AllSubscribershistroyland ROCS
ON ROCS.SubscriberKey = s.SubscriberKey
WHERE ROCS.SLSegment__c = 'S4 - real-love'
AND 'S6 - real-love'
AND s.OYBAccountID = '85208879'
AND s.EventDate >= DATEADD(DAY, -180, GETDATE())
) t
GROUP BY SubscriberKey
所以在“ AllSubscribershistroyland ”中有 2 個列，分別稱為“ S4 - Dutch real-love”和“S6 - real-love ”。我正在嘗試運行查詢以查看這兩列中有多少訂閱者。我似乎無法將它們組合起來，但是當我用一列運行查詢時，我確實得到了結果。我嘗試使用“ AND”組合兩列，但出現錯誤代碼“
保存查詢欄位時出錯。在預期條件的背景關系中指定的非布爾型別的運算式，靠近“AND”。**“
如果有人能幫助我，我將不勝感激
uj5u.com熱心網友回復：
我不完全確定你想做什么，但如果你只是想在同一列的 where 子句中包含你的兩個標題，那么你可以使用 IN 子句：
SELECT SubscriberKey, COUNT(*) AS TotalSentLast180Days
FROM (
SELECT s.SubscriberKey
FROM ENT._Sent s
INNER JOIN ENT.AllSubscribershistroyland ROCS
ON ROCS.SubscriberKey = s.SubscriberKey
WHERE ROCS.SLSegment__c in ('S4 - real-love', 'S6 - real-love')
AND s.OYBAccountID = '85208879'
AND s.EventDate >= DATEADD(DAY, -180, GETDATE())
) t
GROUP BY SubscriberKey
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/533980.html
標籤：数据库
上一篇：MySQLINSERTINTO將每個欄位都設定為null或0？
下一篇：獲取具有所需技能的工人串列