SELECT DISTINCT -- Get people that have addresses without 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) "DESCRPTION" , TO_NUMBER(NULL) "PHONE_ID" , TO_CHAR(NULL) "PHO_TYP_CD_PHONE_TYPE_CODE" , TO_CHAR(NULL) "AREA" , TO_CHAR(NULL) "PREFIX" , TO_CHAR(NULL) "SUFFIX" , TO_CHAR(NULL) "EXT" , TO_DATE(NULL) "PHONE_DATE" , TO_NUMBER(NULL) "ADDR_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) "PHYS_DESC_DATE" , TO_NUMBER(NULL) "PHYS_DESC_ID" FROM PERSON_ADDRESSES PA, ADDRESSES A WHERE PA.ADDRESS_ID = A.ADDRESS_ID AND NOT EXISTS ( SELECT PAP1.PERSON_ID FROM PERSON_ADDR_PHONES PAP1 WHERE PA.PERSON_ID = PAP1.PERSON_ID )