Mysql合并2表找出不同项

SELECT id, time24
FROM (
    SELECT t1.id,t1.time24, t1.time48, t1.time72, t1.time96, t1.timegt96, t1.total, t1.type, t1.platform
        FROM scs_delivery_time_line t1
        UNION ALL
        SELECT t2.id,t2.time24, t2.time48, t2.time72, t2.time96, t2.timegt96, t2.total, t2.type, t2.platform
        FROM scs_delivery_time_line_copy t2
) tbl
GROUP BY id, time24
HAVING count(*) = 1
原文地址:https://www.cnblogs.com/durp/p/9667554.html