Question

oracle 查询出在两个表中某个字段相加起来结果不相等的用户

具体情况就是图片上面描述的，望大神指导一下

Answer 1

select * from (select yhbh,sum(yssl) as sum_yssl from ptb_ysqk where yf>201612 group by yhbh) a,(select yhbh,sum(jtyl) as sum_jtyl from ptb_jtpl group by yhbh) b where a.yhbh=b.yhbh and a.sum_yssl<>b.sum_jtyl;

这样写试一下。