求两个集合的差集,mysql中没有对应的关键字,可以进行合并两个集合,进行分组后如果个数大于1,说明是重复的,如果个数为1,说明是一个集合独自拥有的。
SELECT
id
FROM
(
SELECT DISTINCT
id
FROM
t_request_1
WHERE
id IN (
SELECT
id
FROM
t_request_2
WHERE
a > 0
AND b BETWEEN '1'
AND '2'
)
UNION ALL
SELECT DISTINCT
b.id
FROM
t_request_2 b
WHERE
feMoney > 0
AND requestDate BETWEEN '20170909'
AND '20171130'
) temp
GROUP BY
id
HAVING
COUNT(id) = 1