select NVL((select waterpay.waterend
from waterpay,input
where waterpay.userid=input.userid and rownum<=1 order by year,usemonth desc ),'0')
from dual;
请问这句话错在哪里?该怎么写?
from waterpay,input
where waterpay.userid=input.userid and rownum<=1 order by year,usemonth desc ),'0')
from dual;
请问这句话错在哪里?该怎么写?
from waterpay,input
where waterpay.userid=input.userid and rownum<=1 order by year,usemonth desc
update input
set waterreal=(select nvl(waterpay.waterend,'0')
from waterpay,input
where waterpay.userid=input.userid and rownum<=1 order by year,usemonth desc)
where input.userid=0;
看你的WATERREAL是什么型的?