USE T20K001

select * from RECEIVED_RETURN_GOODS_ADDLESS_DETAIL where bkbillno in (
select billno from opening_bill_detail where gstamt=0 and billdate >='2017-07-01') and LEN(BkSrNo)=6

select * from RECEIVED_RETURN_GOODS_ADDLESS_DETAIL where BkBillNo='' and LEN(bksrno)=6 and BkStatus='UN ADJ'

select * from RECEIVED_RETURN_GOODS_ADDLESS_DETAIL where BkBillNo='' and LEN(bksrno)=6 AND ADJGST=0