SELECT DISTINCT -- Get People's addresses with phones PA.PERSON_ID , TO_CHAR(NULL) "SEX_CODE" , TO_CHAR(NULL) "RACE_CODE" , A.ADDRESS_ID , A.STREET_NAME , A.CITY "ADRS_CITY" , A.STATE_CD_STATE_CODE "ADRS_STATE" , TO_CHAR(NULL) "VEH_COLOR_CODE" , TO_CHAR(NULL) "VEH_TOP_COLOR_CODE" , TO_CHAR(NULL) "VEH_MAKE_CODE" , TO_CHAR(NULL) "VEH_MODEL_CODE" , TO_NUMBER(NULL) "VEHICLE_ID" , TO_NUMBER(NULL) "YEAR" , TO_CHAR(NULL) "ID_NUMBER" , TO_CHAR(NULL) "STATE_CD_STATE_CODE" , TO_CHAR(NULL) "CNTRY_CD_COUNTRY_TYPE_CODE" , TO_CHAR(NULL) "MISC_CD_MISC_ID_CODE" , TO_DATE(NULL) "DATE_OF_ISSUE" , TO_NUMBER(NULL) "SMT_ID" , TO_CHAR(NULL) "BDY_PRT_BODY_PART_CODE" , TO_CHAR(NULL) "SMT_CD_SMT_CODE" , TO_CHAR(NULL) "DESCRIPTION" , PH.PHONE_ID , PH.PHO_TYP_CD_PHONE_TYPE_CODE , PH.AREA , PH.PREFIX , PH.SUFFIX , PH.EXT , PH.DATE_OF_INFO "PHONE_DATE" , PAP.ADDRESS_ID "ADDRESS_ID" , TO_CHAR(NULL) "BLD_CD_BUILD_CODE" , TO_CHAR(NULL) "EYE_CD_EYE_CODE" , TO_CHAR(NULL) "HAIR_LNGTH_HAIR_LENGTH_CODE" , TO_CHAR(NULL) "SKN_CD_SKIN_CODE" , TO_CHAR(NULL) "FACE_HR_FACIAL_HAIR" , TO_CHAR(NULL) "HAIR_CD_HAIR_CODE" , TO_CHAR(NULL) "HEIGHT" , TO_CHAR(NULL) "WEIGHT" , TO_CHAR(NULL) "GLASSES" , TO_DATE(NULL) "PHY_DESC_DATE" , TO_NUMBER(NULL) "PHYS_DESC_ID" FROM PERSON_ADDRESSES PA , ADDRESSES A , PERSON_ADDR_PHONES PAP , PHONES PH WHERE PA.ADDRESS_ID = A.ADDRESS_ID AND PA.ADDRESS_ID = PAP.ADDRESS_ID AND PA.PERSON_ID = PAP.PERSON_ID AND PAP.PHONE_ID = PH.PHONE_ID