outer join psql code example

Example: psql join

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