标签：ym 清理 SELECT 两张 treatment LH1030000 message id MySql
1、
mysql如何两个表取差集_mysql 查询两张表的差集
SELECT * FROM ym_message_internal where treatment_id in
(
SELECT a.treatment_id FROM ym_message_internal a left join LH1030 b on b.LH1030000=a.treatment_id where b.LH1030000 is null
union
SELECT a.treatment_id FROM ym_message_internal a right join LH1030 b on b.LH1030000=a.treatment_id where a.id is null
)
标签：ym,
清理,
SELECT,
两张,
treatment,
LH1030000,
message,
id,
MySql
From： https://www.cnblogs.com/kikyoqiang/p/17183136.html