|
I can't perform "
update spmsb set jhdj = (convert (numeric (20,4), a.xykc * jhdj)--1 * 17) / (a.xykc- -1) from spmsb,
(select spkcb.spidh as spidh, sum (xykc) as xykc from SPKCB, spmsb
where SPKCB.spidh = spmsb.spidh and spkcb.spidh = 3158 group by spkcb.spidh) a
Where spmsb.spidh = a.spidh ", but it can be executed in SQL. Please help experts |
|