mysql - 使用选择查询提取行

Question

我有两个查询如下所示。

 SELECT *
 FROM `nhrd_members` B
 WHERE Membership_Number LIKE 'A%'
 AND `Member_FromDate` >= '2014-01-01'
 AND `Member_FromDate` <= '2015-01-01'

产生 98 行..

 SELECT *
 FROM `nhrd_members` A
 WHERE Membership_Number LIKE 'A%'
 AND `Member_FromDate` >= '2014-01-01'
 AND `Member_FromDate` <= '2014-05-14' 

产生 19 行。

正如您所看到的，我正在从同一个表中提取数据。现在我需要的实际结果是 98-19，即 79 行。

我需要从查询 1 中排除查询 2 的行，并获取 81 条记录。任何帮助表示赞赏。

Answer 1

SELECT *
FROM `nhrd_members` B
WHERE
  Membership_Number LIKE 'A%'
  AND (
    `Member_FromDate` >= '2014-01-01'
    AND `Member_FromDate` <= '2015-01-01'
  )
  AND NOT (
    `Member_FromDate` >= '2014-01-01'
    AND `Member_FromDate` <= '2014-05-14'
  )

可以简化为:

SELECT *
FROM `nhrd_members` B
WHERE
  Membership_Number LIKE 'A%'
  AND (
    `Member_FromDate` > '2014-05-14'
    AND `Member_FromDate` <= '2015-01-01'
  )