postgresql innner join code example Example: psql join SELECT * FROM weather INNER JOIN cities ON (weather.city = cities.name);