update sellInvoice a
set sellTaxNum = (select b.xfsh
from xxfp b
where b.lbdm = a.sortCode
and b.fphm = a.invoiceNum),
fp_lb = 'YB',
yssphm = (select case
when length(b.xfyhzh) >= 7 then
substr(b.xfyhzh, -7, 7)
else
b.xfyhzh
end yssphm
from xxfp b
where b.lbdm = a.sortCode
and b.fphm = a.invoiceNum);
posted on 2011-10-05 17:20
kxbin 閱讀(212)
評論(0) 編輯 收藏 所屬分類:
ORACLE