En COUNTRIES.sql — различия между версиями

Текущая версия на 09:36, 15 мая 2013

/* Display of all TecDoc countries' and groups of countries list */

/* COU_ID - Country ID */

/* COU_CC - Country code (3-letter) */

/* COU_ISO2 - Country code (2-letter), corresponds to Internet domains of the countries: ru, de etc. */

/* COU_CURRENCY_CODE - Currency code */

/* COU_DES_TEXT - Name of the country */

/**/

/* To see the values of bit fields for each country or group of countries add the field output into a query: */

/* COU_CTM */

SET @LNG_ID = 16; /* 1 - German; 16 - Russian*/

SELECT	COU_ID,	COU_CC,	COU_ISO2,	COU_CURRENCY_CODE,	TEX_TEXT AS COU_DES_TEXT
FROM	           COUNTRIES
INNER JOIN DESIGNATIONS ON DES_ID = COU_DES_ID
INNER JOIN DES_TEXTS ON TEX_ID = DES_TEX_ID
WHERE	DES_LNG_ID = @LNG_ID
ORDER BY	COU_ID;

• Back to index page: Tecdoc_queries_and_structure_manual_-_version_2

• Prices and packages for Irbis software based on tecdoc from Mstarproject company: http://www.mstarproject.com/en/?action=tecdoc_mysql_site