ProghubPH
Вопрос из теста Основы SQL
SQL / junior
Даны две таблицы: офисы (offices) и города (cities), в которых эти офисы расположены. Таблицы связаны по city_id. На текущий момент в таблицах есть следующие данные:
 несколько вариантов
offices
|----------------------|
|office_id|name|city_id|
|----------------------|
|        1|of1 |     22|
|        2|of2 |      3|
|        3|of3 |      7|
|----------------------|

cities
|------------------|
|city_id|   name   |
|------------------|
|      3|   Kiev   |
|     22|   Lviv   |
|     25| Krigopol |
|------------------|


Какие из запросов в результате вернут 3 строки?
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 full outer join cities on offices.city_id=cities.city_id;
select offices.name, cities.name from offices right 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;