--˲����selecta.card_code"Ƭ",a.asset_code"ʲ",c.unitcode"������������֯�֯�֯�֯",c.unitname"��",d.code"˲",d.name�����"˲",a.pk_card,a.pk_corp,b.pk_cardhistory,b.fk_accbook�����fromfa_cardainnerjoinfa_cardhistorybona.pk_card=b.fk_cardinnerjoinbd_corpcona.pk_corp=c.pk_corpinnerjoinbd_glbookdonb.fk_accbook=d.pk_glbookwherea.pk_cardin(selectfk_cardfromfa_cardhistorywheredr=0andlaststate_flag='1'groupbyfk_card,fk_accbookhavingcount(pk_cardhistory)>1)anda.dr=0andb.dr=0andb.laststate_flag='1';updatefa_cardhistorysetdr=1wherepk_cardhistoryin(selectmin(pk_cardhistory)fromfa_cardhistorywherepk_corp='��'andfk_accbook='˲'�����andaccyear=2016andperiod=01andfa_cardhistory.dr=0andlaststate_flag='1'groupbyfk_cardhavingcount(pk_cardhistory)>1)------updatefa_cardhistorysetdr=1wherepk_cardhistorynotin(selectmax(pk_cardhistory)fromfa_cardhistorywherepk_corp='1266'andfk_accbook='0001161000000000046Y'andaccyear=2016andperiod=10andfa_cardhistory.dr=0andlaststate_flag='1'groupbyfk_cardhavingcount(pk_cardhistory)>1)andpk_corp='1266'andfk_accbook='0001161000000000046Y'andaccyear=2016andperiod=10andfa_cardhistory.dr=0andlaststate_flag='1'groupbyfk_cardhavingcount(pk_cardhistory)>1;
