|
我有两个要在 BigQuery 中合并的表。我需要根据多个条件过滤数据。我需要返回 url = https://www.mywebpage%、duration = 15000 的所有字段，第三个条件应该获取 action = Midpoint 或 action = Complete。下面是代码：
SELECT
d.duration,
c.action,
c.url
FROM
(
`table_action_url` c
INNER JOIN `table_duration` d ON (d.id = c.id)
)
WHERE c.url LIKE "https://www.mywebpage%"
AND d.duration = '15000'
AND c.action like 'Midpoint'
OR (c.action like 'Complete')
这将返回持续时间和 url 的不同字段，但正确的操作。我还尝试了以下方法：
SELECT
d.duration,
c.action,
c.url
FROM
(
`table_action_url` c
INNER JOIN `table_duration` d ON (d.id = c.id)
)
WHERE (c.url LIKE "https://www.mywebpage%" AND d.duration = '15000' AND c.action like 'Midpoint')
OR (c.url LIKE "https://www.mywebpage%" AND d.duration = '15000' AND c.action like 'Complete')
此查询返回正确的 url 和持续时间，但对于操作，值都是完整的。
期望的输出是：
duration action url
15000 Midpoint https://www.mywebpage
15000 Complete https://www.mywebpage
15000 Midpoint https://www.mywebpage
|