SELECT
*
FROM
test_copy
WHERE
area_name NOT IN (
SELECT
name2
FROM
yt_baseinfo AS base
)
求出A表中的字段不等于B表中的字段
最新推荐文章于 2021-03-08 15:10:19 发布
SELECT
*
FROM
test_copy
WHERE
area_name NOT IN (
SELECT
name2
FROM
yt_baseinfo AS base
)