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 JOIN `countries_rivers` AS cr
- ON c.`country_code` = cr.`country_code`
- LEFT JOIN `rivers` AS r
- ON r.`id` = cr.`river_id`
- ORDER BY c.`country_name`
- LIMIT 5;
Advertisement
Add Comment
Please, Sign In to add comment