一个更新语句

update user_order s set s.area_code = (select t.area_code from isdn_head t where substr(s.user_isdn,1,6)=t.exchg_code or substr(s.user_isdn,1,7)=t.exchg_code or substr(s.user_isdn,1,8)=t.exchg_code )[@more@]

user_order 表，字段user_isdn,area_code
area_code现在是空的，
还有号段表 exchg_code,area_code
能不能一条语句把area_code填上

update user_order s set s.area_code = (select t.area_code from isdn_head t where substr(s.user_isdn,1,6)=t.exchg_code or substr(s.user_isdn,1,7)=t.exchg_code or substr(s.user_isdn,1,8)=t.exchg_code )

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/66233/viewspace-995401/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/66233/viewspace-995401/