Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT TOP(5) c.[CountryName], r.[RiverName]
- FROM [Countries] c
- LEFT JOIN [CountriesRivers] cr ON cr.[CountryCode] = c.[CountryCode]
- LEFT JOIN [Rivers] r ON cr.[RiverId] = r.[Id]
- LEFT JOIN [Continents] cn ON c.[ContinentCode] = cn.[ContinentCode]
- WHERE cn.[ContinentName] = 'Africa'
- ORDER BY c.[CountryName]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement