Intern — Middle
Merging data from two tables
livecode
Task condition
The system contains two tables:
- Person: fields name and CityId
- City: fields Id and name
You need to execute the specified SQL query and determine which rows will be returned.
SELECT *
FROM Person
LEFT OUTER JOIN City
ON Person.CityId = City.Id