Joined: 01/04/2014 07:20:29
I'm quite new to SQL. So the answer to my question might be easy.
My SQLite database got the two geonames standard tables:
The tables column names are also the standard geonames column names.
Searching for a place name in allcountries table is easy.
But how to search this database for an exsisting place name 'including' its alternate names?
How does that work? Can somebody please help and provide a SQL command example to get started?