如何在子查询中使用两个where子句？

Question

我需要查询一组数据(首先在哪里)，并根据该结果与另一个WHERE子查询。使用下面的代码

**Incorrect syntax near the keyword 'where'.**

你能告诉我我在这里做错了什么吗？

 select * from [Analytics]
    WHERE
    DateCreated >= '2014-05-01'
    AND DateCreated < '2014-06-01'
    AND Identification = 'ElementFlow'
    where exists
    (
    SELECT *
    FROM [Analytics]
    WHERE Location = 'x.DetailsAdvertisement' 
    OR Location = 'x.DetailsShop'
    OR Location = 'x.None'
    OR Location = 'x'
    )

Answer 1

您应该将where exists更改为and exists，应该是这样的。

Answer 2

通过删除where子句来两次，尝试这样做。

select * from [Analytics]
    WHERE
    DateCreated >= '2014-05-01'
    AND DateCreated < '2014-06-01'
    AND Identification = 'ElementFlow'
    AND exists
    (
    SELECT *
    FROM [Analytics]
    WHERE Location = 'x.DetailsAdvertisement' 
    OR Location = 'x.DetailsShop'
    OR Location = 'x.None'
    OR Location = 'x'
    )

或者你试试这个。

select * from [Analytics]
        WHERE
        DateCreated >= '2014-05-01'
        AND DateCreated < '2014-06-01'
        AND Identification = 'ElementFlow'
        AND location in ('x.DetailsAdvertisement' ,'x.DetailsShop','x.None','x')

Answer 3

你要用WHERE子句两次。将第二个WHERE替换为和它应该有效。

select * from [Analytics]
WHERE
DateCreated >= '2014-05-01'
AND DateCreated < '2014-06-01'
AND Identification = 'ElementFlow'
AND exists
(
SELECT *
FROM [Analytics]
WHERE Location = 'x.DetailsAdvertisement' 
OR Location = 'x.DetailsShop'
OR Location = 'x.None'
OR Location = 'x'
)