2. Left Join

SELECT C.Code AS "Country Code", C.Name AS "Country", C.Continent, CL.Language, CT.District

FROM ((Country C

LEFT JOIN CountryLanguage CL ON CL.CountryCode = C.Code)

LEFT JOIN City CT ON CT.CountryCode = C.Code)

ORDER BY Country ASC;