SELECT a.*
FROM
newtrsinfocsv a
LEFT JOIN
(SELECT * FROM newtrsinfocsv WHERE goodsType LIKE '%虚拟%') b
ON a.id=b.id
WHERE b.id IS NULL;
Mysql 取余集
最新推荐文章于 2022-10-23 16:55:52 发布
SELECT a.*
FROM
newtrsinfocsv a
LEFT JOIN
(SELECT * FROM newtrsinfocsv WHERE goodsType LIKE '%虚拟%') b
ON a.id=b.id
WHERE b.id IS NULL;