Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- PS.PESO_NRO_SOCIO AS NUMERO_DE_SOCIO,
- P.PERS_NOMBRE AS NOMBRE,
- P.PERS_APELLIDO AS APELLIDO,
- C.CIUD_DESCRIPCION AS CIUDAD,
- B.BARR_DESCRIPCION AS BARRIO,
- IV.INVI_NRO_CASA AS NUMERO_DE_CASA,
- CP.CALL_DESCRIPCION AS CALLE_PRINCIPAL,
- CS.CALL_DESCRIPCION AS CALLE_SECUNDARIA,
- CT.CALL_DESCRIPCION AS CALLE_TERCIARIA
- FROM PERSONAS P
- JOIN PERSONAS_SOCIOS PS ON P.PERS_COD_PERSONA = PS.PESO_COD_PERSONA
- JOIN INMUEBLES_VIVIENDAS IV ON P.PERS_COD_PERSONA = IV.INVI_COD_PERSONA
- JOIN CALLES CP ON IV.INVI_ID_CALLE_PRINCIPAL = CP.CALL_ID_CALLES
- JOIN CIUDADES C ON C.CIUD_ID_CIUDAD = IV.INVI_ID_CIUDAD
- JOIN BARRIOS B ON B.BARR_ID_BARRIO = IV.INVI_ID_BARRIO
- LEFT JOIN CALLES CS ON CS.CALL_ID_CALLES = IV.INVI_ID_CALLE_SECUNDARIA
- LEFT JOIN CALLES CT ON CT.CALL_ID_CALLES = IV.INVI_ID_CALLE_TERCIARIA
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement