我试图通过他们之前是否曾经从我们这里购买过网站访问者来细分网站访问者。当我在 SELECT 语句中放入以下字段时,出现以下错误:
CASE WHEN fullVisitorId IN (SELECT fullVisitorId FROM [xxxx-0000:36363.unique_FullVisitorIds_of_past_purchasers_table]) THEN "Purchased"
ELSE "Never Purchased" END AS Previous_Purchase
错误:“错误:(L10:20):半连接表达式(即“x IN (SELECT ...)”)仅在 WHERE 或 HAVING 子句中受支持。”
我该怎么做呢?
谢谢
我建议按照以下方式加入汇总结果:
SELECT
CASE WHEN p.has_purchased = 1 THEN "Purchased"
ELSE "Never Purchased"
END AS Previous_Purchase
FROM existing_from_table f
LEFT JOIN (
SELECT fullVisitorId, 1 has_purchased
FROM [xxxx-0000:36363.unique_FullVisitorIds_of_past_purchasers_table]
GROUP BY fullVisitorId
) p on f.fullVisitorId = p.fullVisitorId
nb:使用 group by 以便不影响总行数。
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句