select pk_glorgbook from bd_glorgbook where glorgbookcode='0100-0001';--0001N510000000006K4X

select no,period,year,dr,pk_voucher from gl_voucher where no='' and dr='' and period='' and year='' and

pk_glorgbook='0001N510000000006K4X';

update gl_voucher set no='' where pk_voucher='1162N51000000001YHZ3';

update gl_detail set nov=''where pk_voucher='1162N51000000001YHZ3';

select no,period,year,dr,gl_voucher.explanation, pk_voucher from gl_voucher where no in('','','','' )

and dr='' and period='' and year='' and pk_glorgbook='0001N510000000006K4X' for update;

select pk_voucher from gl_voucher v where v.pk_glorgbook in

(select pk_glorgbook from bd_glorgbook where glorgbookcode='012101-0001')

and v.dr=0 and  v.year=2014 and v.period=12 and v.no=55  --1076N510000000004GX8

select d.explanation,d.modifyflag  from gl_detail d where d.pk_voucher='1076N510000000004GX8' for update --YYYYYYYYYYYYYYYY

select d.explanation, d.modifyflag,d.detailindex,d.pk_systemv

  from gl_detail d

 where d.pk_voucher in (select pk_voucher

                          from gl_voucher v

                         where v.pk_glorgbook in

                               (select pk_glorgbook

                                  from bd_glorgbook

                                 where glorgbookcode = '012101-0001')--账簿

                           and v.dr = 0

                           and v.year = 2014  --年月凭证号

                           and v.period = 12

                           and v.no = 55 )

   for update --YYYYYYYYYYYYYYYY

select v.explanation ,v.totalcredit,no

from gl_voucher v

where no in('','','','' )

and period=''

and year=''

and pk_glorgbook='0001N510000000006K4X'

for update;