select * from pp p where p.id not in (select pid from qq q)
两表单独查询没错,一起查询报错,后来发现是后面的子查询结果不能为null
select * from pp p where p.id not in (select pid from qq q where q.pid is not null )
not in使用报错
最新推荐文章于 2023-03-15 11:26:03 发布
select * from pp p where p.id not in (select pid from qq q)
两表单独查询没错,一起查询报错,后来发现是后面的子查询结果不能为null
select * from pp p where p.id not in (select pid from qq q where q.pid is not null )