将第一个查询结果引用以签入另一个表

Question

我有以下查询

SELECT abm_took_id FROM pos_took WHERE DELETEDDATE IS NOT NULL

它从表 pos_took 中获取 abm_took_id 的值。

现在还有另一个表pos_eook它由列cbm_bookid组成，列是外键，即第一个表的（pos_took）主键abm_took_id是第二个表（pos_eook）的外键，如cbm_bookid。

现在我必须检查从第一个查询引用中提取的abm_took_id是否在第二个表中，例如abm_took_id=44555从第一个查询中提取出来，现在它是否存在于第二个表中，请告知查询我可以在哪里使用或存在运算符。

Answer 1

如果您尝试查找第一个表（查询）中不在第二个表中的所有引用：

SELECT abm_took_id
FROM pos_took
WHERE DELETEDDATE IS NOT NULL and
      abm_took_id not in (select cbm_bookid
                          from pos_eook
                          where cbm_bookid is not null
                         );