mysql - 如何从mysql中另外两个表的并集中不存在的表中选择所有记录

Question

我想返回其他两个表的联合中不存在的所有记录，但是当我尝试包含联合的结果时，工作台返回语法错误。我做错了什么？

SELECT TransactionID
from transactions 
where transactionid not in

(
(select distinct Transactionid
from transactionsdebits 
where   accountid like '81%')

union

(select distinct TransactionID
from transactionscredits
where accountid like '81%')
)
;

Answer 1

您可以尝试以下 -

    SELECT TransactionID
    from transactions 
    where transactionid not in ( select transactionid from
     (
       select distinct Transactionid
       from transactionsdebits 
       where   accountid like '81%'
       union
       select distinct TransactionID
       from transactionscredits
       where accountid like '81%'
     )
   A)