--多账簿selecta.card_code"卡片编号",a.asset_code"资产编码",c.code"组织编号",c.name"组织名称",d.code"账簿编号",d.name"账簿名称",a.pk_card,a.pk_org,b.pk_cardhistory,b.pk_accbookfromfa_cardainnerjoinfa_cardhistorybona.pk_card=b.pk_cardinnerjoinorg_financeorgcona.pk_org=c.pk_financeorginnerjoinorg_accountingbookdonb.pk_accbook=d.pk_accountingbookwherea.pk_cardin(selectpk_cardfromfa_cardhistorywheredr=0andlaststate_flag='Y'groupbypk_card,pk_accbookhavingcount(pk_cardhistory)>1)anda.dr=0andb.dr=0andb.laststate_flag='Y'updatefa_cardhistorysetdr=1wherepk_cardhistoryin(selectmin(pk_cardhistory)fromfa_cardhistorywherepk_org='0001N9100000000004UF'andpk_accbook='1002A1100000001XSSTZ'andaccyear=2016andperiod=01andfa_cardhistory.dr=0andlaststate_flag='Y'groupbypk_cardhavingcount(pk_cardhistory)>1)
