help with sql query

[eluser]Sumon[/eluser]
Lets consider UK country id is 1.

Code:

$CountryId=1;  //Change as needed
SELECT Cnt.country_name, City.city_name
FROM country Cnt join (city as City)
ON (Cnt.country_id=City.country_id)
WHERE Cnt.country_id=$CountryId