Inhalt der Tabelle
LIEGT_AN
Das Ergebnis der Anfrage SELECT * FROM LIEGT_AN hat 357 Zeilen mit 7 Spalten:
| id | ST_NAME | LT_ID | L_ID | F_NAME | S_NAME | M_NAME |
|---|
| 1 | Aarhus | DK | DK | | | Ostsee |
| 2 | Abidjan | CI | CI | | | Atlantischer_Ozean |
| 3 | Abu_Dhabi | UAE | UAE | | | Persischer_Golf |
| 4 | Accra | GH | GH | | | Atlantischer_Ozean |
| 5 | Addis_Abeba | ETH | ETH | | | |
| 6 | Adelaide | SUE | AUS | | | Indischer_Ozean |
| 7 | Aden | ADN | ADN | | | Golf_von_Aden |
| 8 | Ahwaz | KHU | IR | Karun | | |
| 9 | Ajaccio | COR | F | | | Mittelmeer |
| 10 | Alexandria | ET | ET | | | Mittelmeer |
| 11 | Algier | DZ | DZ | | | Mittelmeer |
| 12 | Aracaju | SER | BR | | | Atlantischer_Ozean |
| 13 | Archangelsk | RSF | RUS | Noerdliche_Dwina | | |
| 14 | Arendal | AA | N | | | Nordsee |
| 15 | Aschaffenburg | BAY | D | Main | | |
| 16 | Astrachan | RSF | RUS | Wolga | | |
| 17 | Asuncion | PY | PY | Paraguay | | |
| 18 | Athen | GR | GR | | | Mittelmeer |
| 19 | Augsburg | BAY | D | Lech | | |
| 20 | Bad_Hersfeld | HES | D | Fulda | | |
| 21 | Bad_Tölz | BAY | D | Isar | | |
| 22 | Baku | ASB | RUS | | Kaspisches_Meer | |
| 23 | Bamako | RMM | RMM | Niger | | |
| 24 | Bangui | RCA | RCA | Ubangi | | |
| 25 | Banjul | WAG | WAG | | | Atlantischer_Ozean |
| 26 | Basseterre | SCN | SCN | | | Karibisches_Meer |
| 27 | Baton_Rouge | LA | USA | Mississippi_River | | |
| 28 | Bautzen | SA | D | Spree | | |
| 29 | Beirut | RL | RL | | | Mittelmeer |
| 30 | Belem | PAR | BR | | | Atlantischer_Ozean |
| 31 | Belfast | NOR | GB | | | Irische_See |
| 32 | Bengasi | LAR | LAR | | | Mittelmeer |
| 33 | Bergen | HO | N | | | Nordsee |
| 34 | Berlin | B | D | Spree | | |
| 35 | Bernburg | SA | D | Saale | | |
| 36 | Bismarck | ND | USA | Missouri_River | | |
| 37 | Bissau | GUB | GUB | | | Atlantischer_Ozean |
| 38 | Bodoe | NO | N | | | Europaeisches_Nordmeer |
| 39 | Bombay | MAH | IND | | | Indischer_Ozean |
| 40 | Bonn | NRW | D | Rhein | | |
| 41 | Brandenburg | BRB | D | Havel | | |
| 42 | Brazzaville | RCB | RCB | Zaire | | |
| 43 | Bremen | HB | D | Weser | | |
| 44 | Bremerhafen | HB | D | Weser | | |
| 45 | Bridgetown | BDS | BDS | | | Atlantischer_Ozean |
| 46 | Brisbane | QUE | AUS | | | Pazifischer_Ozean |
| 47 | Budapest | H | H | Donau | | |
| 48 | Buenos_Aires | BUN | RA | Rio_de_la_Plata | | |
| 49 | Bujumbura | BU | BU | | Tanganjikasee | |
| 50 | Cardiff | WAL | GB | | | Irische_See |
| 51 | Casablanca | MA | MA | | | Atlantischer_Ozean |
| 52 | Castries | WL | WL | | | Karibisches_Meer |
| 53 | Celle | NIE | D | Aller | | |
| 54 | Ceuta | CAD | E | | | Mittelmeer |
| 55 | Charlottetown | PE | CDN | | | Atlantischer_Ozean |
| 56 | Chicago | IL | USA | | Lake_Michigan | |
| 57 | Ciudad_de_Panama | PA | PA | | | Pazifischer_Ozean |
| 58 | Conakry | GUI | GUI | | | Atlantischer_Ozean |
| 59 | Corrientes | CES | RA | Parana | | |
| 60 | Cottbus | BRB | D | Spree | | |
| 61 | Dakar | SN | SN | | | Atlantischer_Ozean |
| 62 | Daressalam | EAT | EAT | | | Indischer_Ozean |
| 63 | Deggendorf | BAY | D | Donau | | |
| 64 | Dessau | SA | D | Elbe | | |
| 65 | Dessau | SA | D | Mulde | | |
| 66 | Detroit | MI | USA | | Lake_Erie | |
| 67 | Dillingen | SAR | D | Saar | | |
| 68 | Djibuti | RD | RD | | | Golf_von_Aden |
| 69 | Donauwörth | BAY | D | Donau | | |
| 70 | Drammen | BU | N | | | Nordsee |
| 71 | Dresden | SN | D | Elbe | | |
| 72 | Duala | CAM | CAM | | | Atlantischer_Ozean |
| 73 | Dubai | UAE | UAE | | | Persischer_Golf |
| 74 | Dublin | IRL | IRL | | | Irische_See |
| 75 | Duesseldorf | NRW | D | Rhein | | |
| 76 | Duisburg | NRW | D | Rhein | | |
| 77 | Durres | AL | AL | | | Mittelmeer |
| 78 | Eilenburg | SN | D | Mulde | | |
| 79 | El_Alaiun | DARS | DARS | | | |
| 80 | Emden | NIE | D | Ems | | |
| 81 | Emsdetten | NRW | D | Ems | | |
| 82 | Esbjerg | DK | DK | | | Nordsee |
| 83 | Espoo | UUS | SF | | | Ostsee |
| 84 | Flensburg | SWH | D | | | Ostsee |
| 85 | Florianopolis | SAN | BR | | | Atlantischer_Ozean |
| 86 | Formosa | FOR | RA | Paraguay | | |
| 87 | Forst | BRB | D | Neiße | | |
| 88 | Fortaleza | CEA | BR | | | Atlantischer_Ozean |
| 89 | Frankfurt/M | HES | D | Main | | |
| 90 | Frankfurt/O | BRB | D | Oder | | |
| 91 | Freetown | WAL | WAL | | | Atlantischer_Ozean |
| 92 | Friedrichshafen | BAW | D | | Bodensee | |
| 93 | Fulda | HES | D | Fulda | | |
| 94 | Fürstenwalde | BRB | D | Spree | | |
| 95 | Füssen | BAY | D | | Forggensee | |
| 96 | Gabarone | RB | RB | | | |
| 97 | Gaevle | X | S | | | Ostsee |
| 98 | Georgetown | GUY | GUY | | | Atlantischer_Ozean |
| 99 | Goeteborg | O | S | Goetaaelv | | Ostsee |
| 100 | Grimma | SN | D | Mulde | | |
| 101 | Guayaquil | EC | EC | | | Pazifischer_Ozean |
| 102 | Görlitz | SN | D | Neiße | | |
| 103 | Göttingen | NIE | D | Leine | | |
| 104 | Haernoesand | Y | S | | | Ostsee |
| 105 | Hafnarfjoerdur | IS | IS | | | Atlantischer_Ozean |
| 106 | Halifax | NS | CDN | | | Atlantischer_Ozean |
| 107 | Halle | SA | D | Saale | | |
| 108 | Halmstad | N | S | | | Ostsee |
| 109 | Hamar | HE | N | | Mjoesensee | |
| 110 | Hamburg | HH | D | Elbe | | |
| 111 | Hameln | NIE | D | Weser | | |
| 112 | Hartford | CT | USA | Connecticut_River | | |
| 113 | Havanna | C | C | | | Golf_von_Mexiko |
| 114 | Heilbronn | BAW | D | Neckar | | |
| 115 | Helsinki | UUS | SF | | | Ostsee |
| 116 | Honolulu | HI | USA | | | Pazifischer_Ozean |
| 117 | Höxter | NRW | D | Weser | | |
| 118 | Ingolstadt | BAY | D | Donau | | |
| 119 | Iquitos | PE | PE | Amazonas | | |
| 120 | Irkutsk | RSF | RUS | | Baikalsee | |
| 121 | Jaunde | CAM | CAM | | | |
| 122 | Jefferson_City | MO | USA | Missouri_River | | |
| 123 | Jena | TH | D | Saale | | |
| 124 | Joao_Pessoa | PBA | BR | | | Atlantischer_Ozean |
| 125 | Joenkoeping | F | S | | Vaettersee | |
| 126 | Joensuu | NKA | SF | | Orisee | |
| 127 | Johannesburg | RSA | RSA | | | |
| 128 | Jyvaeskylae | MFI | SF | | Paeijaenne | |
| 129 | Kairo | ET | ET | Nil | | Mittelmeer |
| 130 | Kalmar | H | S | | | Ostsee |
| 131 | Kampala | EAU | EAU | | Victoriasee | |
| 132 | Kansas_City | MO | USA | Missouri_River | | |
| 133 | Kapstadt | RSA | RSA | | | Atlantischer_Ozean |
| 134 | Karlskrona | K | S | | | Ostsee |
| 135 | Karlsruhe | BAW | D | Rhein | | |
| 136 | Karlstad | S | S | Klaraelv | Vaenersee | |
| 137 | Kassel | HES | D | Fulda | | |
| 138 | Kempten | BAY | D | Iller | | |
| 139 | Khartum | EAS | EAS | Nil | | |
| 140 | Kiel | SWH | D | | | Ostsee |
| 141 | Kiew | UA | UA | Dnepr | | |
| 142 | Kigali | RWA | RWA | | | |
| 143 | Kingston | JA | JA | | | Karibisches_Meer |
| 144 | Kingstown | WV | WV | | | Karibisches_Meer |
| 145 | Kinshasa | ZRE | ZRE | Zaire | | |
| 146 | Koblenz | RPF | D | Rhein | | |
| 147 | Koblenz | RPF | D | Mosel | | |
| 148 | Konstanz | BAW | D | | Bodensee | |
| 149 | Konz | SAR | D | Saar | | |
| 150 | Konz | SAR | D | Mosel | | |
| 151 | Kopenhagen | DK | DK | | | Ostsee |
| 152 | Kotka | KYM | SF | | | Ostsee |
| 153 | Krasnojarsk | RSF | RUS | Jenissej | | |
| 154 | Kristiansand | VA | N | | | Nordsee |
| 155 | Kuibyschew | RSF | RUS | Wolga | | |
| 156 | Kuopio | KUO | SF | | Kallasee | |
| 157 | Kuwait_City | KT | KT | | | Persischer_Golf |
| 158 | Köln | NRW | D | Rhein | | |
| 159 | Lagos | WAN | WAN | | | Atlantischer_Ozean |
| 160 | Lahti | HAE | SF | | Paeijaenne | |
| 161 | Landsberg | BAY | D | Lech | | |
| 162 | Landshut | BAY | D | Isar | | |
| 163 | Lappeenrenta | KYM | SF | | Saimasee | |
| 164 | Leningrad | RSF | RUS | Newa | | Ostsee |
| 165 | Leverkusen | NRW | D | Rhein | | |
| 166 | Libreville | GAB | GAB | | | Atlantischer_Ozean |
| 167 | Lillehammer | OP | N | | Mjoesensee | |
| 168 | Lindau | BAW | D | | Bodensee | |
| 169 | Lingen | NIE | D | Ems | | |
| 170 | Little_Rock | AR | USA | Arkansas_River | | |
| 171 | Lobito | RPA | RPA | | | Atlantischer_Ozean |
| 172 | Lome | TG | TG | | | Atlantischer_Ozean |
| 173 | London | ENG | GB | Themse | | |
| 174 | Los_Angeles | CA | USA | | | Pazifischer_Ozean |
| 175 | Luanda | RPA | RPA | | | Atlantischer_Ozean |
| 176 | Ludwigshafen | RPF | D | Rhein | | |
| 177 | Luleo | BD | S | | | Ostsee |
| 178 | Lusaka | Z | Z | | | |
| 179 | Lutherstadt_Wittenberg | SA | D | Elbe | | |
| 180 | Lyon | RHO | F | Rhone | | |
| 181 | Macao | MAC | P | | | Suedchinesisches_Meer |
| 182 | Macapa | APA | BR | Amazonas | | |
| 183 | Maceio | ALA | BR | | | Atlantischer_Ozean |
| 184 | Madras | TAN | IND | | | Indischer_Ozean |
| 185 | Magdeburg | SA | D | Elbe | | |
| 186 | Mainz | RPF | D | Rhein | | |
| 187 | Malmoe | M | S | | | Ostsee |
| 188 | Managua | NIC | NIC | | Nicaragua_See | |
| 189 | Manama | BRN | BRN | | | Persischer_Golf |
| 190 | Manaus | AMA | BR | Amazonas | | |
| 191 | Mannheim | BAW | D | Neckar | | |
| 192 | Mannheim | BAW | D | Rhein | | |
| 193 | Mannheim | BAW | D | Neckar | | |
| 194 | Maputo | MOS | MOS | | | Indischer_Ozean |
| 195 | Maracaibo | YV | YV | | Maracaibo_See | Karibisches_Meer |
| 196 | Mariestad | R | S | | Vaenersee | |
| 197 | Marseille | PRO | F | | | Mittelmeer |
| 198 | Maseru | LS | LS | | | |
| 199 | Mbabane | SD | SD | | | |
| 200 | Meiningen | TH | D | Werra | | |
| 201 | Meißen | SN | D | Elbe | | |
| 202 | Melbourne | VIC | AUS | | | Pazifischer_Ozean |
| 203 | Melilla | CAD | E | | | Mittelmeer |
| 204 | Meppen | NIE | D | Ems | | |
| 205 | Merseburg | SA | D | Saale | | |
| 206 | Miami | FL | USA | | | Atlantischer_Ozean |
| 207 | Mikkeli | MIK | SF | | Saimasee | |
| 208 | Minden | NIE | D | Weser | | |
| 209 | Mmabatho | JB | JB | | | |
| 210 | Mogadischu | SP | SP | | | Indischer_Ozean |
| 211 | Molde | MR | N | | | Europaeisches_Nordmeer |
| 212 | Mombasa | EAK | EAK | | | Indischer_Ozean |
| 213 | Monaco-Ville | MC | MC | | | Mittelmeer |
| 214 | Monrovia | LB | LB | | | Atlantischer_Ozean |
| 215 | Montevideo | U | U | Rio_de_la_Plata | | Atlantischer_Ozean |
| 216 | Montreal | PQ | CDN | St._Lorenzstrom | | |
| 217 | Moroni | KOM | KOM | | | Indischer_Ozean |
| 218 | Moss | OES | N | | | Nordsee |
| 219 | Mühldorf | BAY | D | Inn | | |
| 220 | München | BAY | D | Isar | | |
| 221 | Nantes | PAY | F | Loire | | |
| 222 | Narvik | NO | N | | | Europaeisches_Nordmeer |
| 223 | Nassau | BS | BS | | | Atlantischer_Ozean |
| 224 | Natal | RGN | BR | | | Atlantischer_Ozean |
| 225 | NDjamena | TCH | TCH | Schari | | |
| 226 | Neubrandenburg | MV | D | | Tollensesee | |
| 227 | Neuburg | BAY | D | Donau | | |
| 228 | New_York | NY | USA | Hudson_River | | |
| 229 | New_York | NY | USA | | | Atlantischer_Ozean |
| 230 | Niamey | RN | RN | Niger | | |
| 231 | Nienburg | NIE | D | Weser | | |
| 232 | Nuakschott | RIM | RIM | | | |
| 233 | Nuuk | GR | DK | | | Atlantischer_Ozean |
| 234 | Oran | DZ | DZ | | | Mittelmeer |
| 235 | Orleans | CEN | F | Loire | | |
| 236 | Oslo | OS | N | | | Nordsee |
| 237 | Oslo | AK | N | | | Nordsee |
| 238 | Ouagadougou | BF | BF | | | |
| 239 | Oulu | OUL | SF | Oulujoki | | Ostsee |
| 240 | Panaji | GDD | IND | | | Indischer_Ozean |
| 241 | Paramaribo | SME | SME | | | Atlantischer_Ozean |
| 242 | Parana | ENT | RA | Parana | | |
| 243 | Paris | ILE | F | Seine | | |
| 244 | Passau | BAY | D | Donau | | |
| 245 | Passau | BAY | D | Inn | | |
| 246 | Perth | WES | AUS | | | Indischer_Ozean |
| 247 | Pierre | SD | USA | Missouri_River | | |
| 248 | Pori | TUP | SF | Kokemaeenjoki | | |
| 249 | Porto_Alegre | RGS | BR | | | Atlantischer_Ozean |
| 250 | Porto_Novo | RPB | RPB | | | |
| 251 | Port_au_Prince | RH | RH | | | Karibisches_Meer |
| 252 | Port_Blair | ANI | IND | | | Indischer_Ozean |
| 253 | Port_Louis | MS | MS | | | Indischer_Ozean |
| 254 | Port_of_Spain | TT | TT | | | Atlantischer_Ozean |
| 255 | Posadas | MIS | RA | Parana | | |
| 256 | Potsdam | BRB | D | Havel | | |
| 257 | Prag | CZ | CZ | Moldau | | |
| 258 | Praia | KAP | KAP | | | Atlantischer_Ozean |
| 259 | Pretoria | RSA | RSA | | | |
| 260 | Providence | RI | USA | | | Atlantischer_Ozean |
| 261 | Quebec | PQ | CDN | St._Lorenzstrom | | |
| 262 | Rabat | MA | MA | | | Atlantischer_Ozean |
| 263 | Rasht | GIL | IR | | Kaspisches_Meer | |
| 264 | Rathenow | BRB | D | Havel | | |
| 265 | Recife | PER | BR | | | Atlantischer_Ozean |
| 266 | Regensburg | BAY | D | Donau | | |
| 267 | Resistencia | CHA | RA | Parana | | |
| 268 | Reykjavik | IS | IS | | | Atlantischer_Ozean |
| 269 | Rheine | NRW | D | Ems | | |
| 270 | Riedlingen | BAW | D | Donau | | |
| 271 | Riesa | SN | D | Elbe | | |
| 272 | Riga | LT | LT | Westliche_Dwina | | Ostsee |
| 273 | Rio_de_Janeiro | RIO | BR | | | Atlantischer_Ozean |
| 274 | Rosario | SFE | RA | Parana | | |
| 275 | Roseau | WD | WD | | | Karibisches_Meer |
| 276 | Rosenheim | BAY | D | Inn | | |
| 277 | Rostock | MV | D | | | Ostsee |
| 278 | Rouen | HAU | F | Seine | | |
| 279 | Rovaniemi | LAP | SF | Ounasjoki | | |
| 280 | Rovaniemi | LAP | SF | Kemijoki | | |
| 281 | Saarbrücken | SAR | D | Saar | | |
| 282 | Saarlouis | SAR | D | Saar | | |
| 283 | Saint_Georges | WG | WG | | | Karibisches_Meer |
| 284 | Saint_Johns | AUB | AUB | | | Karibisches_Meer |
| 285 | Salisbury | ZW | ZW | | | |
| 286 | Salt_Lake_City | UT | USA | | Great_Salt_Lake | |
| 287 | Salvador | BAH | BR | | | Atlantischer_Ozean |
| 288 | Santa_Fe | SFE | RA | Parana | | |
| 289 | Santo_Domingo | DOM | DOM | | | Karibisches_Meer |
| 290 | San_Diego | CA | USA | | | Pazifischer_Ozean |
| 291 | San_Francisco | CA | USA | | | Pazifischer_Ozean |
| 292 | Sao_Luis | MAR | BR | | | Atlantischer_Ozean |
| 293 | Sao_Tome | SAO | SAO | | | Atlantischer_Ozean |
| 294 | Schwedt | BRB | D | Oder | | |
| 295 | Schweinfurt | BAY | D | Main | | |
| 296 | Schwerin | MV | D | | Schweriner_See | |
| 297 | Shkoder | AL | AL | | Skutarisee | |
| 298 | Siegmaringen | BAW | D | Donau | | |
| 299 | St._Johns | NF | CDN | | | Atlantischer_Ozean |
| 300 | St._Louis | MO | USA | Mississippi_River | | |
| 301 | St._Louis | MO | USA | Missouri_River | | |
| 302 | St._Paul | MN | USA | Mississippi_River | | |
| 303 | Sta._Isabel | RGE | RGE | | | |
| 304 | Starnberg | BAY | D | | Starnberger_See | |
| 305 | Stavanger | RO | N | | | Nordsee |
| 306 | Steinkjer | NT | N | | | Europaeisches_Nordmeer |
| 307 | Stockholm | AB | S | | Maelarsee | Ostsee |
| 308 | Stralsund | MV | D | | | Ostsee |
| 309 | Straubing | BAY | D | Donau | | |
| 310 | Stuttgart | BAW | D | Neckar | | |
| 311 | Svolvaer | NO | N | | | Europaeisches_Nordmeer |
| 312 | Sydney | NSW | AUS | | | Pazifischer_Ozean |
| 313 | Tallinn | EST | EST | | | Ostsee |
| 314 | Tampere | HAE | SF | | Naesisee | |
| 315 | Tbilissi | GEO | RUS | Kura | | |
| 316 | Thorshavn | FA | DK | | | Atlantischer_Ozean |
| 317 | Torgau | SN | D | Elbe | | |
| 318 | Toronto | ON | CDN | | Lake_Ontario | |
| 319 | Toulouse | MID | F | Garonne | | |
| 320 | Trier | SAR | D | Mosel | | |
| 321 | Tripolis | LAR | LAR | | | Mittelmeer |
| 322 | Trivandrum | KER | IND | | | Indischer_Ozean |
| 323 | Tromsoe | TR | N | | | Europaeisches_Nordmeer |
| 324 | Trondheim | ST | N | | | Europaeisches_Nordmeer |
| 325 | Tunis | TN | TN | | | Mittelmeer |
| 326 | Turku | TUP | SF | | | Ostsee |
| 327 | Tübingen | BAW | D | Neckar | | |
| 328 | Ulm | BAW | D | Donau | | |
| 329 | Ulm | BAW | D | Iller | | |
| 330 | Umeo | AC | S | Umeaelv | | |
| 331 | Vaasa | VAA | SF | | | Ostsee |
| 332 | Vadsoe | FI | N | | | Barentssee |
| 333 | Vaenersborg | P | S | Goetaaelv | Vaenersee | |
| 334 | Vaesteros | U | S | | Maelarsee | |
| 335 | Valletta | M | M | | | Mittelmeer |
| 336 | Valparaiso | RCH | RCH | | | Pazifischer_Ozean |
| 337 | Vancouver | BC | CDN | | | Pazifischer_Ozean |
| 338 | Victoria | SY | SY | | | Indischer_Ozean |
| 339 | Victoria | BC | CDN | | | Pazifischer_Ozean |
| 340 | Visby | I | S | | | Ostsee |
| 341 | Vitoria | ESP | BR | | | Atlantischer_Ozean |
| 342 | Vlore | AL | AL | | | Mittelmeer |
| 343 | Völklingen | SAR | D | Saar | | |
| 344 | Waldshut_Tiengen | BAW | D | Rhein | | |
| 345 | Waren | MV | D | | Müritz | |
| 346 | Warendorf | NRW | D | Ems | | |
| 347 | Warschau | PL | PL | Weichsel | | |
| 348 | Weisenfels | SA | D | Saale | | |
| 349 | Wellington | NZ | NZ | | | Pazifischer_Ozean |
| 350 | Wilhelmshafen | NIE | D | | | Nordsee |
| 351 | Windhuk | SWA | SWA | | | |
| 352 | Wladiwostok | RSF | RUS | | | Japanisches_Meer |
| 353 | Worms | RPF | D | Rhein | | |
| 354 | Wurzen | SN | D | Mulde | | |
| 355 | Würzburg | BAY | D | Main | | |
| 356 | Yellowknife | NW | CDN | | Great_Slave_Lake | |
| 357 | Zittau | SN | D | Neiße | | |