smt_backfarerate5,
smt_addfare,
smt_regbybanktrans,
smt_regbylibrarycard,
--smt_defaultpassword,
smt_regbycodes,
smt_addfarerate1,
smt_addfare1,
smt_addfarerate2,
smt_addfare2,
smt_backfarerate3,
smt_addfarerate3,
smt_addfare3,
smt_depreciation,
smt_lagdate,
--addsmt_addfarerate4,
--addsmt_addfare4,
smt_validday )=
(select
smt_iccardcode,
smt_iccardname,
smt_iccardexplain,
smt_deposit,
smt_backdeposit,
smt_addfarerate,
smt_backaddfare,
smt_losspoundage,
smt_damagepoundage,
smt_istemporary,
smt_dailycode,
smt_dailyno,
smt_regbylist,
smt_regbybank,
smt_regbyfinger,
smt_validdate,
smt_onemonthinmoneytimes,
smt_onemonthmaxmoney,
smt_onemonthoutmoneytimes,
smt_onemonthoutmaxmoney,
smt_function,
smt_addfare4,
smt_deposit4,
smt_addfarerate4,
smt_backfarerate5,
smt_addfare,
smt_regbybanktrans,
smt_regbylibrarycard,
--smt_defaultpassword,
smt_regbycodes,
smt_addfarerate1,
smt_addfare1,
smt_addfarerate2,
smt_addfare2,
smt_addfarerate3,
smt_addfare3,
smt_depreciation,
smt_lagdate,
--addsmt_addfarerate4,
--addsmt_addfare4,
smt_validday
from _iccardsort where smt_iccardcode=d.smt_iccardcode)
where exists(
select 1 from _iccardsort s where s.smt_iccardcode=d.smt_iccardcode and
not (
s.smt_iccardname = d.smt_iccardname and
s.smt_iccardexplain = d.smt_iccardexplain and
s.smt_deposit = d.smt_deposit and
s.smt_backdeposit = d.smt_backdeposit and
s.smt_addfarerate= d.smt_addfarerate and
s.smt_backaddfare = d.smt_backaddfare and
s.smt_losspoundage = d.smt_losspoundage and
s.smt_damagepoundage = d.smt_damagepoundage and
s.smt_istemporary = d.smt_istemporary and
s.smt_dailycode= d.smt_dailycode and
s.smt_dailyno =d.smt_dailyno and
s.smt_regbylist =d.smt_regbylist and
s.smt_regbybank =d.smt_regbybank and
s.smt_regbyfinger= d.smt_regbyfinger and
s.smt_validdate = d.smt_validdate and
s.smt_onemonthinmoneytimes = d.smt_onemonthinmoneytimes and
s.smt_onemonthmaxmoney=d.smt_onemonthmaxmoney and
s.smt_onemonthoutmoneytimes =d.smt_onemonthoutmoneytimes and
s.smt_onemonthoutmaxmoney = d.smt_onemonthoutmaxmoney and
s.smt_function = d.smt_function and
s.smt_addfare4 = d.smt_addfare4 and
s.smt_deposit4 = d.smt_deposit4 and
s.smt_addfarerate4 = d.smt_addfarerate4 and
s.smt_backfarerate5 = d.smt_backfarerate5 and
s.smt_addfare = d.smt_addfare and
s.smt_regbybanktrans =d.smt_regbybanktrans and
s.smt_regbylibrarycard = d.smt_regbylibrarycard and
--smt_defaultpassword,
s.smt_regbycodes = d.smt_regbycodes and
s.smt_addfarerate1 = d.smt_addfarerate1 and
s.smt_addfare1 =d.smt_addfare1 and
s.smt_addfarerate2 = d.smt_addfarerate2 and
s.smt_addfare2 = d.smt_addfare2 and
s.smt_backfarerate3 = d.smt_backfarerate3 and
s.smt_addfarerate3 =d.smt_addfarerate3 and
s.smt_addfare3 =d.smt_addfare3 and
s.smt_depreciation = d.smt_depreciation and
s.smt_lagdate = d.smt_lagdate and
--addsmt_addfarerate4,
--addsmt_addfare4,
s.smt_val