Hi,

I need to create a rather complex MySQL query.
Here is the description:

I want a query which generates a Table from 5 Tables, but what it finds in Tables 1 through 4 must not be in Table 5.
Put another way in regular language with some MySQL interjected in it, this is what should happen:

SELECT distinct(email) FROM Table, T1, T2, T3, T4, T5
Where date <x and date > y for looking into T1, T2, T3, T4
AND the email that you find in T1, T2, T3, T4 for this date range does not exist in T5 for the entire date range of T5.

Some more background info: Tables T1, T2, T3, T4 have a few million records in them over their 4 year date range.
T5 has few 1000 records in it during the same date range.

Regards,