use T24S001

select * from received_bank_book_ADDLESS_detail WHERE BKBILLNO NOT IN (SELECT BILLNO FROM BILL_DETAIL  UNION SELECT BILLNO FROM OPENING_BILL_DETAIL ) AND BKBILLNO<>''
select * from RECEIVED_RETURN_GOODS_ADDLESS_DETAIL WHERE BKBILLNO NOT IN (SELECT BILLNO FROM BILL_DETAIL  UNION SELECT BILLNO FROM OPENING_BILL_DETAIL ) AND BKBILLNO<>''