1、两表关联更新
update cc_vcagentnumber set vcid = b.vcid from cc_vcagentnumber a,cc_desk b where b.deskphone=a.telnumber and b.vcid > 0 and b.clienttype = 1 and a.vcid<>b.vcid and a.vcid = 0 and a.clienttype = 1 go
