Hi,

I have 2 tables 'ecastdata' and 'ecastops'. I am running a COUNT on the number of records from the 'ecastdata' table with a specific ID from both tables.

I am excluding certain email addresses from both tables. The email addresses in the 'ecastdata' table are in one column: |Email|.
The 'ecastops' table has the email addresses in seperate columns, for example: |EcastOpSeed1|EcastOpSeed2|EcastOpSeed3|

The problem is the query does not seem to get a value from the column: |EcastOpSeed3|
When I run the query the total count result is 7734 and should be 7733 records.

Plese Help!!!

Here is the query I'm using:

SELECT COUNT(*) AS intTotal FROM ecastdata where ecastdata.EcastID = 46 AND
(ecastdata.Email NOT LIKE '%yahoo.com' AND ecastdata.Email NOT LIKE '%hotmail.com' AND
 ecastdata.Email NOT LIKE
(SELECT ecastops.EcastOpSeed1 FROM ecastops WHERE ecastops.EcastOpID = 46) AND
 ecastdata.Email NOT LIKE
(SELECT ecastops.EcastOpSeed2 FROM ecastops WHERE ecastops.EcastOpID = 46) AND
 ecastdata.Email NOT LIKE
(SELECT ecastops.EcastOpSeed3 FROM ecastops WHERE ecastops.EcastOpID = 46))

Cross Post:


http://p2p.wrox.com/topic.asp?TOPIC_ID=27966