Say I have 2 Tables:
And T1 has fields:
T2 has fields:
How do I do a Select on these 2 tables for a given date range with the condition that they do not have the same matching
email during that date range?
FYI I have tried this SELECT which seems like it should work, but this is not working, it is returning wrong data:
SELECT COUNT(T1_id) FROM T2, T1
WHERE submited_date>='2009-06-20' AND submited_date<='2009-06-24'
AND T1.email != T2.email;
Looking forward to your suggestions.