CREATE TABLE `City` (
	`id_City`	INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
	`CityName`	TEXT NOT NULL
);

CREATE TABLE `Person` (
	`id_Person`	INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
	`PersonName`	TEXT NOT NULL
);

CREATE TABLE `JoinTable` (
	`id_Person`	INTEGER NOT NULL
	`id_City`	INTEGER NOT NULL,
);

SELECT City.CityName
FROM City
INNER JOIN JoinTable
ON City.id_City = JoinTable.id_City
WHERE JoinTable.id_Person = 1;