SELECT DISTINCT -- Get people that have phones without an address PH.PER_PERSON_ID "PERSON_ID" , TO_CHAR(NULL) "SEX_CODE" , TO_CHAR(NULL) "RACE_CODE" , TO_NUMBER(NULL) "ADDRESS_ID" , TO_CHAR(NULL) "STREET_NAME" , TO_CHAR(NULL) "ADRS_CITY" , TO_CHAR(NULL) "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" , TO_NUMBER(NULL) "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 PHONES PH WHERE PH.PER_PERSON_ID IS NOT NULL AND PH.PHONE_ID NOT IN ( -- Make sure person's phone hasn't already been retrieved SELECT DISTINCT(PAP2.PHONE_ID) FROM PERSON_ADDR_PHONES PAP2 WHERE PH.PER_PERSON_ID = PAP2.PERSON_ID )