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