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