mysql 两个结果集求差

方法一：通俗易懂，效率低
SELECT
t.*
FROM
ns_unpaid t
WHERE
currOrg_ORGID = 30
AND regisDT = ‘2018-09-10’
AND shiftId = ‘1’
and t.id not in (select unpaid_id from ns_unpaiddetail)

方法二：较难理解，效率高
SELECT
t.*
FROM
ns_unpaid t
left join (select unpaid_id as i from ns_unpaiddetail) t1 on t.id = t1.i
WHERE
currOrg_ORGID = 30
AND regisDT = ‘2018-09-10’
AND shiftId = ‘1’
and t1.i is null