Mirineo

Untitled

Jun 10th, 2021
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. SELECT c.`country_name`, r.`river_name`
  2. FROM `countries` AS c
  3. LEFT JOIN `countries_rivers` AS cr
  4. ON c.`country_code` = cr.`country_code`
  5. LEFT JOIN `rivers` AS r
  6. ON r.`id` = cr.`river_id`
  7. ORDER BY c.`country_name`
  8. LIMIT 5;
Advertisement
Add Comment
Please, Sign In to add comment