How to correctly compose an SQL query, 3 tables, the same field names?

Question

MySQL

SQL worker,

I see that I chose all 3 fields as I need
But does not want to work in the script, it gives out only Russia

$sql = "SELECT city.name, region.name, country.name
FROM city, region, country
WHERE city.city_id = ?i AND region.region_id = ?i AND  country.country_id = ?i";

$geo = $db->getall($sql,$ank['city_id'],$ank['regionid'],$ank['countryid']);

array (size=1)
  0 => 
    array (size=1)
      'name' => string 'Россия' (length=12)

Answer 1

$sql = "SELECT city.name as city_name, region.name as region_name , country.name as country_name
FROM city, region, country
WHERE city.city_id = ?i AND region.region_id = ?i AND  country.country_id = ?i";

$geo = $db->getall($sql,$ank['city_id'],$ank['regionid'],$ank['countryid']);

Answer 2

For a script with CROSS JOIN separated by commas, it would be nice to shoot you. How are table data related?
Ideally the script should look something like this:

select something from city as c
INNER JOIN region as r ON c.regionId = r.Id
INNER JOIN country as co ON co.Id = r.countryId
WHERE some condition