是否可以编写一个查询来检查任一子查询(而不是一个子查询)是否正确？

LỰA CHỌN *
FROM employees e
WHERE NOT EXISTS
        (
        SELECT null 
        FROM eotm_dyn d
        WHERE d.employeeID = e.id
        ) OR (select * FROM table c WHERE c.employeeID = e.id)

1 Câu trả lời

你的问题有点难以理解，但我猜这就是你所要求的。它将返回 employees 表中的记录，这些记录在表 eotm_dyn Và bàn 中没有任何相关行。

LỰA CHỌN *
FROM employees e
WHERE e.id NOT IN
    (
        (SELECT employeeID 
        FROM eotm_dyn)
     UNION
        (SELECT employeeID 
        FROM table)
    )

关于php - Mysql WHERE NOT EXISTS(查询)OR(查询)，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/17286681/