SELECT cities.name
FROM   cities, customers
WHERE  customers.city_id = cities.city_id
  AND  customers.credit_rating > 700

##</code><code>##

SELECT (cities.name)
  FROM (customers JOIN cities USING (city_id))
 WHERE (customers.credit_rating > 700)