SELECT offices.name, cities.name FROM offices FULL OUTER JOIN cities ON offices.city_id=cities.city_id;
SELECT offices.name, cities.name FROM offices INNER JOIN cities ON offices.city_id=cities.city_id;
SELECT offices.name, cities.name FROM offices LEFT OUTER JOIN cities ON offices.city_id=cities.city_id;
SELECT offices.name, cities.name FROM offices CROSS JOIN cities
SELECT offices.name, cities.name FROM offices RIGHT OUTER JOIN cities ON offices.city_id=cities.city_id;