LEFT JOIN
用左(右)连接来求差集,由于需要实施两个表连接会导致笛卡尔积效应其输出集的记录行可能会增多,若不是一对一或一对多,我们应该将多对多的情况处理成多对一后才进行连接,否则输出的记录集肯能不正确。
SELECT
a.* FROM smd_employee a
LEFT JOIN asd_user b
ON b.phone = a.employee_phone AND b.orderId = a.orderId
WHERE
b.phone IS NULL
AND b.orderId IS NULL;