Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- c.country_name, r.river_name
- FROM countries AS c
- LEFT OUTER JOIN countries_rivers AS cr
- ON c.country_code = cr.country_code
- LEFT OUTER JOIN rivers AS r
- ON r.id = cr.river_id
- WHERE c.continent_code = 'AF'
- ORDER BY c.country_name ASC
- LIMIT 5
Advertisement
Add Comment
Please, Sign In to add comment