> "Michael Richards" <[EMAIL PROTECTED]> writes:
>> The reduction of the list doesn't seem to be terribly efficient.
>> Here are some strategies I've been looking at:
>
>> select id from users WHERE
>> id not in (select userid from sentletters where lettertype=1) AND
>> aclgroup IN (1,2);
>
> Try
"Michael Richards" <[EMAIL PROTECTED]> writes:
> The reduction of the list doesn't seem to be terribly efficient. Here
> are some strategies I've been looking at:
> select id from users WHERE
> id not in (select userid from sentletters where lettertype=1) AND
> aclgroup IN (1,2);
I've got 2 tables, one with a list of users (has only about 5000
entries) and another with a list of userids that have already been
sent letters. I'm trying to efficiently join these two so I get every
user who hasn't been sent a letter. The problem is, coupled with the
5 other joins on the us
