Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT TOP (5) c.CountryName,
- r.RiverName
- FROM Countries AS c
- JOIN CountriesRivers AS cr
- ON c.CountryCode = cr.CountryCode
- RIGHT JOIN Rivers AS r
- ON cr.RiverId = r.Id
- WHERE c.CountryCode ='AF'
- ORDER BY c.CountryName ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement