-- This query returns all countries and their
-- mega cities if they have
SELECT C.Name, M.Name, M.Population
FROM Example.Countries AS C
OUTER APPLY Example.GetMegaCities(C.CountryID) AS M