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 )
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 )