postgres join where example

Example: psql join

SELECT *
    FROM weather INNER JOIN cities ON (weather.city = cities.name);