peshopbs2

Untitled

Dec 1st, 2019
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. SELECT
  2. c.country_name, r.river_name
  3. FROM countries AS c
  4. LEFT OUTER JOIN countries_rivers AS cr
  5. ON c.country_code = cr.country_code
  6. LEFT OUTER JOIN rivers AS r
  7. ON r.id = cr.river_id
  8. WHERE c.continent_code = 'AF'
  9. ORDER BY c.country_name ASC
  10. LIMIT 5
Add Comment
Please, Sign In to add comment