I am trying to create a query that will exclude certain records. I have joined a table with (ID) name/address to a table with ID and activity.
So table one has: record 10 John Smith 123 Main Street
Table two has: 3 records for John Smith (ID=10)
- 10 | donor
- 10 | yard sign
- 10 | canvasser
I want to run a query where I exclude anyone (John Smith) who already has a yard sign. If I say not 'yard sign' in my criteria, I still get John Smith because he has donor and canvasser records.
Thanks
__._,_.___
Posted by: jan.hertzsch@gmail.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar