Given the <i>Offices</i> and <i>Cities</i> tables

Given the Offices and Cities tables that are connected by city_id and containing following data in them:

Offices
|----------------------|
|office_id|name|city_id|
|----------------------|
|        1|of1 |     22|
|        2|of2 |      3|
|        3|of3 |      7|
|----------------------|

Cities
|------------------|
|city_id|   name   |
|------------------|
|      3|   Kyiv   |
|     22|   London   |
|     25| Bangkok |
|------------------|

Which of the following queries will return 3 records in a result set?


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 left 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 right outer join cities on offices.city_id=cities.city_id;


select offices.name, cities.name from offices cross join cities

Explanation

Left join returns all records from the first table even if some of them do not have matches in right table.

1 (1)

Подобається

Ввійдіть щоб вподобати
Комментувати

Ввійдіть щоб прокоментувати
Поширити

Tweet

Тести з
SQL

Приєднуйся і вивчай SQL

або Дізнайся більше про Тести з SQL онлайн

Слідкуй за CodeGalaxy

Мобільний додаток Beta

Зворотній Зв’язок