Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Provincias.StrNombre as Provincia, STUFF(
- (SELECT ',' + s.strnombre
- FROM Municipios s
- WHERE s.stridprovincia = Municipios.stridprovincia
- order by s.strnombre
- FOR XML PATH('')),1,1,'') AS Municipos
- FROM Municipios INNER JOIN
- Provincias ON Municipios.StrIdProvincia = Provincias.StrIdProvincia
- GROUP BY Provincias.StrNombre, Municipios.stridprovincia
- order by 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement