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 取余集
最新推荐文章于 2024-03-18 17:15:40 发布
SELECT a.*
FROM
newtrsinfocsv a
LEFT JOIN
(SELECT * FROM newtrsinfocsv WHERE goodsType LIKE '%虚拟%') b
ON a.id=b.id
WHERE b.id IS NULL;