SELECT PROSPECT.[First Name], PROSPECT.[Last Name], PROSPECT.[House Number], PROSPECT.[Middle Initial], PROSPECT.[Pre-directional], PROSPECT.Street, PROSPECT.[Post-directional], PROSPECT.[Street Suffix], PROSPECT.[Apartment Number], PROSPECT.City, PROSPECT.State, PROSPECT.[ZIP +4], PROSPECT.[ZIP Code], PROSPECT.[County Code], PROSPECT.[County Name], PROSPECT.Phone, PROSPECT.[Phone Number], PROSPECT.[Estimated Home Value], PROSPECT.[Estimated Household Income], PROSPECT.[Adjusted Annual Income], PROSPECT.[Adjusted Home Value], PROSPECT.[Census Block Group], PROSPECT.[% Owner Occupied], PROSPECT.[Census Tract], PROSPECT.ID, PROSPECT.[Metro Area], PROSPECT.Comments
FROM PROSPECT LEFT JOIN [FTC-DNC-LIST] ON PROSPECT.[Phone] = [FTC-DNC-LIST].[Phone]
WHERE ((([FTC-DNC-LIST].Phone) Is Null));
Posted by: federalhillrent@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Please zip all files prior to uploading to Files section.
Tidak ada komentar:
Posting Komentar