Where should I post a question about SQL??

Just having trouble understanding how to use a natural join in postgreSQL 9.0.....


I have


SELECT Country.Name, City.Name, City.Population FROM Country, City WHERE Country.Population < 5000;

I just don't understand how to rewrite this using joins?

this place is fine.

your query is bad since there's nothing in the where clause to connect the country and city.

SELECT Country.Name, City.Name, City.Population FROM Country co
inner join City ci
on ci.countryid=co.countryid
WHERE co.Population < 5000;