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 阅读(202)
评论(0) 编辑 收藏 所属分类:
ORACLE