Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT SUM(C.ID)
- FROM
- (
- SELECT C.COMUNIDAD AS COMUNIDAD,COUNT(C.ID) AS ID
- FROM
- (
- SELECT C.COMUNIDAD AS COMUNIDAD,T.ID_CARRETERA AS ID
- FROM TRAMO AS T,
- (
- SELECT COMUNIDADI AS COMUNIDAD,ID_TRAMO
- FROM COMUNIDADXTRAMO
- WHERE
- COMUNIDADI IN
- (
- SELECT ID_COMUNIDAD
- FROM COMUNIDAD
- )
- UNION SELECT ID_TRAMO, COMUNIDADF
- FROM COMUNIDADXTRAMO
- WHERE
- COMUNIDADF NOT IN
- (
- SELECT COMUNIDADI
- FROM COMUNIDADXTRAMO
- )
- ORDER BY COMUNIDAD
- ) AS C
- WHERE T.ID_TRAMO = C.ID_TRAMO
- ) AS C
- GROUP BY COMUNIDAD
- ORDER BY COMUNIDAD
- ) AS C
- WHERE C.ID>1
Add Comment
Please, Sign In to add comment