Queries that use a join always baffle me so I could use some expert advice. Thanks in advance...
How to I write a ColdFusion query where:
I have one database called "Visitors"
I have 2 tables in that database:
"Users" is a table with my entire membership listing
"EmailSent" is a table listing every newsletter sent to each member
The common field is "UserID"
Within EmailSent is a field called "TemplateUsed" which is a different template for each version of the newsletter.
I need a query that will output the UserID's of those members who did not yet receive a particular template called "ImportedCareerCoach5.cfm"
But they may have received other newsletters.
Hope that makes sense.
I'm running CF 10 and MS SQL