We usually expect some additional content in the body of the email. What you have provided is a fairly simple SQL select statement that left joins a couple tables.
All records from the Prospect table that aren't in the Do Not Call table will display.
Duane Hookom MVP
MS Access
To: AccessDevelopers@yahoogroups.com
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));
All records from the Prospect table that aren't in the Do Not Call table will display.
Duane Hookom MVP
MS Access
To: AccessDevelopers@yahoogroups.com
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: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Please zip all files prior to uploading to Files section.
.
__,_._,___
Tidak ada komentar:
Posting Komentar