2021-03-18

最新推荐文章于 2021-11-10 17:26:45 发布

茂密头发的源猴

最新推荐文章于 2021-11-10 17:26:45 发布

阅读量219

点赞数

本文链接：https://blog.csdn.net/weixin_48109576/article/details/114969359

版权

select * from dwd.settlement_user_pay
where （p_batch_code != '20210130_TCBXP(JK-HX-SF)' ） or(a_system !='jk' and b_system !='hx' and p_batch_code = '20210130_TCBXP(JK-HX-SF)')

（p_batch_code != '20210130_TCBXP(JK-HX-SF)' 取的是settlement_user_pay 表里的数据

or 并集将（p_batch_code != '20210130_TCBXP(JK-HX-SF)' 和or(a_system !='jk' and b_system !='hx' and p_batch_code = '20210130_TCBXP(JK-HX-SF)') union在一起

等于

select * from dwd.settlement_user_pay where a_system !='jk' and b_system !='hx' and p_batch_code = '20210130_TCBXP(JK-HX-SF)'
union

select * from dwd.settlement_user_pay where p_batch_code != '20210130_TCBXP(JK-HX-SF)'