Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT [PeakName], [RiverName],
- LOWER(CONCAT(
- [PeakName],
- SUBSTRING([RiverName], 2, LEN([RiverName]))
- )) AS [Mix]
- FROM [Peaks], [Rivers]
- WHERE RIGHT([PeakName], 1) = LEFT([RiverName], 1)
- ORDER BY [Mix]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
