English
Country
SELECT DISTINCT b.BranchID, b.BranchName, b.CountryID FROM website.branches b WHERE b.BranchID IN (SELECT DISTINCT(w.BranchID) FROM website.websites w WHERE w.CountryID NOT IN (0,1,8,19,24,53,86,106,113,115,116,126,132,134,138,183,197,200,210,221,232,258,260,261,269) AND w.ContactBranch NOT IN ('Asia Pacific', 'Argentina', 'Brazil', 'Chile', 'Mexico')) ORDER BY b.BranchName = 'International', b.BranchNameUS
Austria
\n
Belgium
\n
Canada
\n
Czech Republic
\n
Far Eastern Europe
\n
France
\n
Germany
\n
Hungary
\n
Ireland
\n
Italy
\n
Latin America
\n
Lithuania
\n
Netherlands
\n
Nordic Region
\n
Poland
\n
Romania
\n
Slovakia
\n
Spain
\n
Switzerland
\n
Ukraine
\n
United Kingdom
\n
United States
\nSELECT CountryID FROM website.websites WHERE CountryName = 'United States'
Rest of the World
\n
Language
Český (Czech)
English
Français (French)
Deutsch (German)
Magyar (Hungarian)
Italiano (Italian)
Polski (Polish)
Русский (Russian)
Română (Romanian)
Slovenský (Slovakian)
Español (Spanish)
×
*
*
*
*
Bema
x
| 1 of 0 |
>>
Displaying 1 - 0 out of 0 items