SQL抽取 A表中不含B表中的记录(多列比较)

 

t3m_data表中的数据如下:
GZD_BH, NSRSBH, BH
'001', '43122741', '1'
'002', '43122742', '2'
'003', '43122743', '3'
'004', '43122744', '4'
'004', '43122741', '8'
'005', '43122745', '5'
'005', '43122741', '9'
'006', '43122746', '6'
'006', '43122741', '7'

t3m_zhgl_data表中数据如下:
GZD_BH, NSRSBH, DATA
'001', '43122741', '1'
'002', '43122742', '2'
'003', '43122743', '3'
'005', '43122745', '5'

 

select gzd_bh,nsrsbh from t3m_data a
where  not exists
(
select gzd_bh,nsrsbh from t3m_zhgl_data b where a.gzd_bh=b.gzd_bh and a.nsrsbh=b.nsrsbh
)
运行结果:
gzd_bh, nsrsbh
'004', '43122744'
'006', '43122746'
'006', '43122741'
'004', '43122741'
'005', '43122741'