һ
	select * from DB_COUNTRY;
ȷݡûݣѴļµdb_country뵽ݿӦִС

ڶ޸
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='UK';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='BA';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='CZ';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='CRO';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='HR';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='GU';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='MDV';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='MV';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='ME';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='MNE';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='AA';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='AN';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='MK';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='NC';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='PF';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='PM';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='PR';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='RE';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='RS';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='SV';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='TT';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='AE';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='AF';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='AL';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='AM';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='AO';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='AR';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='AT';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='AU';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='AZ';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='BD';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='BE';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='BF';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='BG';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='BH';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='BI';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='BJ';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='BL';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='BN';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='BO';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='BR';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='BW';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='BY';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='CA';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='CF';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='CG';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='CH';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='CL';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='CM';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='CN';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='CO';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='CR';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='CS';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='CU';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='CY';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='DE';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='DK';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='DO';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='DZ';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='EC';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='EE';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='EG';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='ES';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='ET';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='FI';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='FJ';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='FR';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='GA';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='GB';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='GD';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='GE';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='GH';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='GN';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='GR';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='GT';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='HK';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='HN';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='HU';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='ID';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='IE';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='IL';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='IN';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='IQ';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='IR';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='IS';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='IT';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='JM';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='JO';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='JP';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='KG';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='KH';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='KR';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='KT';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='KW';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='KZ';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='LA';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='LB';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='LC';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='LI';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='LK';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='LR';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='LT';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='LU';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='LV';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='LY';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='MA';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='MC';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='MD';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='MG';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='ML';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='MM';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='MN';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='MO';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='MT';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='MU';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='MW';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='MX';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='MY';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='MZ';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='NA';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='NE';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='NG';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='NI';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='NL';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='NO';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='NP';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='NZ';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='OM';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='PA';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='PE';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='PG';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='PH';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='PK';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='PL';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='PT';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='PY';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='QA';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='RO';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='RU';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='SA';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='SC';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='SD';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='SE';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='SG';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='SI';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='SK';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='SM';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='SN';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='SO';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='SY';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='SZ';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='TD';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='TG';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='TH';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='TJ';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='TM';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='TN';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='TR';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='TW';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='TZ';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='UA';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='UG';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='US';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='UY';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='UZ';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='VC';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='VE';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='VN';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='YE';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='YU';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='ZA';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='ZM';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='ZR';
update db_order set customerreserve2 = nvl((select countryname from DB_COUNTRY where countryid=db_order.customerqq),'֪') where customerqq='ZW';