I have a table called myUsers with 1000 UserID's. This table is the result of a query.
I have another table called EmailSent that records every email sent to a UserID and which EmailTemplate was used.
How do I get the subset of those 1000 myUsers that have not yet received EmailTemplate = "Template1.cfm"
This is so I can send the remainder of the UserIDs, the email.
I could do this with spaghetti code but prefer to do it within a CFquery tag.