There
are 2 tables: Offices and Cities. They are linked by City_id. At the moment
these tables have the following data

Which
of the next queries will return 3 rows?

Question

There
are 2 tables: Offices and Cities. They are linked by City_id. At the moment
these tables have the following data

Which
of the next queries will return 3 rows?

Answer

SELECT  Offices.Name, Cities.Name FROM Offices LEFT OUTER JOIN Cities ON Offices.City_id=Cities.City_id;

Answer

SELECT  Offices.Name, Cities.Name FROM Offices INNER JOIN Cities ON Offices.City_id=Cities.City_id;

Answer

SELECT  Offices.Name, Cities.Name FROM Offices RIGHT OUTER JOIN Cities ON Offices.City_id=Cities.City_id;

Answer

SELECT  Offices.Name, Cities.Name FROM Offices CROSS JOIN Cities

Answer

SELECT  Offices.Name, Cities.Name FROM Offices FULL OUTER JOIN Cities ON Offices.City_id=Cities.City_id;

Crowdly