Advertisement
Guest User

Untitled

a guest
Jun 6th, 2020
167
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. SELECT TOP (5) c.CountryName,
  2. r.RiverName
  3. FROM Countries AS c
  4. JOIN CountriesRivers AS cr
  5. ON c.CountryCode = cr.CountryCode
  6. RIGHT JOIN Rivers AS r
  7. ON cr.RiverId = r.Id
  8. WHERE c.CountryCode ='AF'
  9. ORDER BY c.CountryName ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement