-- correction diverse
ALTER TABLE rdvhisto CHANGE COLUMN LIBELLE LIBELLE LONGTEXT NULL DEFAULT NULL AFTER DATE;


UPDATE profil p SET p.LIB_PRO = '' WHERE p.LIB_PRO IS NULL;
UPDATE file_attente fa SET fa.COD_FAT = '' WHERE fa.COD_FAT IS NULL;

DELETE i FROM importidentite AS i LEFT JOIN modeleidentite mi ON mi.ID_MID = i.ID_MID
WHERE mi.ID_MID IS NULL;

-- mise à jour de données de la V1 où certaines consultations n'avaient de type de consultation
UPDATE consultation c SET c.TYP_CSL = 'SAN' WHERE c.TYP_CSL = '';


-- modification des items PAYS afin d'ajouter leur code
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "PT" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ACORES MADERE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "AF" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "AFGHANISTAN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "ZA" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "AFRIQUE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "AL" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ALBANIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "DZ" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ALGERIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "DE" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ALLEMAGNE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "AD" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ANDORRE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "AO" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ANGOLA";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "AG" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ANTIGUA";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "SA" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ARABIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "AR" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ARGENTINE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "AM" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ARMENIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "AU" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "AUSTRALIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "AT" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "AUTRICHE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "AZ" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "AZERBAIDJAN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "BS" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "BAHAMAS";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "BH" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "BAHREIN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "BD" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "BANGLADESH";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "BB" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "BARBADE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "BE" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "BELGIQUE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "BZ" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "BELIZE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "BJ" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "BENIN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "BT" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "BHOUTAN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "BY" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "BIELORUSSIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "MM" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "BIRMANIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "BO" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "BOLIVIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "BA" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "BOSNIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "BW" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "BOTSWANA";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "BR" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "BRESIL";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "BN" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "BRUNEI";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "BG" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "BULGARIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "BF" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "BURKINA";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "BI" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "BURUNDI";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "CM" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "CAMEROUN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "KH" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "CAMBODGE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "CA" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "CANADA";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "CV" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "CAP";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "CF" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "CENTRAFRIQUE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "CL" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "CHILI";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "CN" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "CHINE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "CY" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "CHYPRE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "CO" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "COLOMBIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "KM" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "COMORES";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "CG" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "CONGO";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "KP" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "COREE NORD";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "KR" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "COREE SUD";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "CR" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "COSTA";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "CI" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "COTE IVOIRE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "HR" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "CROATIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "CU" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "CUBA";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "DK" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "DANEMARK";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "DJ" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "DJIBOUTI";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "DO" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "DOMINICAIN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "DM" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "DOMINIQUE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "EG" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "EGYPTE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "EC" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "EQUATEUR";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "AE" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "EMIRATS";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "ER" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ERYTHREE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "ES" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ESPAGNE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "EE" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ESTONIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "US" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ETATS UNIS";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "ET" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ETHIOPIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "CD" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "EX ZAIRE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "FJ" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "FIDJI";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "FI" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "FINLANDE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "FR" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "FRANCE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "GA" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "GABON";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "GM" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "GAMBIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "GE" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "GEORGIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "GH" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "GHANA";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "GI" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "GIBRALTAR";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "GR" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "GRECE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "GD" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "GRENADE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "GL" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "GROENLAND";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "GT" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "GUATEMALA";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "GN" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "GUINEE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "GW" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "GUINEE BIS";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "GQ" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "GUINEE EQU";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "GY" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "GUYANE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "HT" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "HAITI";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "HN" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "HONDURAS";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "HU" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "HONGRIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "PN" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ILES PITCA";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "IN" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "INDE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "ID" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "INDONESIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "IQ" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "IRAK";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "IR" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "IRAN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "IE" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "IRLANDE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "IS" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ISLANDE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "IL" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ISRAEL";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "IT" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ITALIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "JM" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "JAMAIQUE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "JP" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "JAPON";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "JO" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "JORDANIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "KZ" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "KAZAKHSTAN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "KE" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "KENYA";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "KG" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "KIRGHIZISTAN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "KI" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "KIRIBATI";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "XK" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "KOSOVO";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "KW" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "KOWEIT";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "LA" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "LAOS";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "LS" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "LESOTHO";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "LV" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "LETTONIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "LB" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "LIBAN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "LR" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "LIBERIA";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "LY" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "LIBYE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "LI" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "LIECHTENSTEIN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "LT" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "LITHUANIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "LU" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "LUXEMBOURG";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "MO" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "MACAO";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "MK" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "MACEDONIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "MG" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "MADAGASCAR";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "MY" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "MALAISIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "MW" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "MALAWI";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "MV" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "MALDIVES";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "ML" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "MALI";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "MT" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "MALTE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "MO" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "MAROC";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "MH" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "MARSHALL";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "MU" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "MAURICE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "MR" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "MAURITANIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "YT" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "MAYOTTE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "MX" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "MEXIQUE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "FM" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "MICRONESIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "MD" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "MOLDAVIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "MC" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "MONACO";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "MN" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "MONGOLIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "ME" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "MONTENEGRO";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "MZ" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "MOZAMBIQUE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "NA" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "NAMIBIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "NR" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "NAURU";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "NP" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "NEPAL";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "NI" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "NICARAGUA";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "NE" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "NIGER";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "NG" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "NIGERIA";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "NO" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "NORVEGE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "NZ" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "NOUVELLE ZELAND";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "OM" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "OMAN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "UG" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "OUGANDA";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "UZ" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "OUZBEKISTAN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "PK" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "PAKISTAN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "PW" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "PALAOS";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "PS" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "PALESTINE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "PA" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "PANAMA";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "PG" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "PAPOUASIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "PY" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "PARAGUAY";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "NL" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "PAYS BAS";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "AN" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "PAYS BAS AMER";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "PE" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "PEROU";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "PH" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "PHILIPPINES";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "PL" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "POLOGNE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "PT" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "PORTUGAL";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "QA" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "QATAR";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "CZ" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "REP.TCHEQUE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "RO" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ROUMANIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "GB" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ROYAUME-UNI";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "RU" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "RUSSIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "RW" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "RWANDA";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "EH" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "SAHARA OCC";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "SB" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "SALOMON";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "SV" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "SALVADOR";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "WS" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "SAMOA OCCI";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "ST" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "SAO TOME";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "SN" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "SENEGAL";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "RS" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "SERBIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "SC" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "SEYCHELLES";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "SL" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "SIERRA LEONE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "SG" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "SINGAPOUR";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "SK" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "SLOVAQUIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "SI" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "SLOVENIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "SO" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "SOMALIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "SD" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "SOUDAN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "LK" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "SRI LANKA";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "KN" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ST CHRISTO";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "SM" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ST MARIN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "VC" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ST VINCENT";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "SH" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "STE HELENE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "LC" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "STE LUCIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "SE" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "SUEDE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "CH" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "SUISSE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "SR" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "SURINAM";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "SZ" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "SWAZILAND";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "SY" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "SYRIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "TJ" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "TADJIKISTAN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "TW" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "TAIWAN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "TZ" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "TANZANIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "TD" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "TCHAD";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "PR" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "TERR USA";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "TH" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "THAILANDE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "TG" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "TOGO";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "TO" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "TONGUA";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "TT" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "TRINITE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "TN" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "TUNISIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "TM" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "TURKMENISTAN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "TR" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "TURQUIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "TV" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "TUVALU";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "UA" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "UKRAINE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "UY" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "URUGUAY";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "VU" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "VANUATU";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "VA" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "VATICAN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "VE" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "VENEZUELA";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "VN" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "VIETNAM";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "YE" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "YEMEN";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "ZM" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ZAMBIE";
UPDATE itemnomenclature pays LEFT JOIN nomenclature n ON n.ID_NMC = pays.ID_NMC SET pays.CPL_IN = "ZW" WHERE n.COD_NMC = "PAY" AND pays.LIB_IN = "ZIMBABWE";