I'm using Acajoom to send out Registration alerts. I like to send out reminders to those that have not yet registered, so I need to remove the emails that have registered from the mailing list of that event. I'm using SQL2Excel.
I'm trying to write an SQL statement that will spit out all of the emails of the people that have NOT registered for an event. So, I need to select all of the emails from jos_acajoom_subscribers, join it to jos_acajoom_queue so I only select those people that have opted in for a certain list_id, and finally I have to join that email list to jos_dtregister_user where that certain eventId=x. I almost have it, but something is holding me up.
Any help is appreciated:
SELECT a.email
FROM jos_acajoom_subscribers as a, jos_dtregister_user as b, jos_acajoom_queue as c
where b.id=c.subscriber_id and c.list_id=3 and a.eventId=2 and b.userEmail=null
This will report nothing is found. I'm trying to find all of the emails from jos_acajoom_subscribers that have no match in jos_dtregister_user.
