Altering WHERE clause to avoid duplicate entries

[horseturtle]

Hi,

 

I have a table with three fields - City, Country and Population.

 

I am using a SELECT to list all possible combination's of each Country and City.

 

SELECT c1.Name, c1.Country, c2.Name, c2.Country

FROM City AS c1, City AS c2

WHERE c1.Country != c2.Country;

 

However when I use this command I get duplicate combination's for each, eg.

 

City A | Country A | City B | Country B

City B | Country B | City A | Country A

 

How can I alter the WHERE clause to stop this happening?

[fenway]

That doesn't make sense -- you can't random mix cities from one country with another country???