select a.* from mtr_doc_rec a,mtr_stk_rec b
where (a.corp='HK11111111' or a.corp = 'CN22222222') and a.doc_status = 'F'
and a.doc_date >= '20021214' and a.doc_date <= '20030314'
and a.corp<>b.corp and a.mtr_id<>b.mtr_id;
where (a.corp='HK11111111' or a.corp = 'CN22222222') and a.doc_status = 'F'
and a.doc_date >= '20021214' and a.doc_date <= '20030314'
and a.corp<>b.corp and a.mtr_id<>b.mtr_id;
select a.* from mtr_doc_rec a
where (a.corp='HK11111111' or a.corp = 'CN22222222') and a.doc_status = 'F'
and a.doc_date >= '20021214' and a.doc_date <= '20030314'
not exists(select doc_no from mtr_stk_rec b where a.corp = b.corp and a.mtr_id = b.mtr_id )