体彩兑奖修正未获取工号

admin

update LOTTERYREDEEM set FIELD4='修正' FIELD1=  to_char(TO_CHAR(storecode) ||  TO_CHAR('09'))
where   FIELD3 IS NOT NULL AND FIELD1 IS NULL

admin

select * from LOTTERYREDEEM where FIELD3 IS NOT NULL AND FIELD1 IS NULL