Hi,

I am wanting to exlude the coulmn |EcastOpSeed1| in my "subquery" using a wildcard.I am extracting results from 2 tables 'ecastdata' and 'ecastops'.

The coulmn |EcastOpSeed1| in 'ecastops' table contains domain-names that I want to exclude from the overall selection.

How do I implement the % wildcard in the sub SELECT query

Something like??:
(
 SELECT %ecastops.EcastOpSeed1 FROM ecastops WHERE
 ecastops.EcastOpID = 46 AND ecastops.EcastOpSeed1 IS NOT NULL
)

Please help!

Here is my full query:


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

Try This....

SELECT COUNT(*) AS intTotal
FROM ecastdata
WHERE ecastdata.EcastID = 46
AND ecastdata.Email NOT LIKE '%hotmail.com.com'
AND ecastdata.Email NOT LIKE '%yahoo.com'
AND NOT EXISTS(
 SELECT * FROM ecastops WHERE
 ecastops.EcastOpID = 46 AND ecastops.EcastOpSeed1 IS NOT NULL
 AND ecastdata.Email like '%'+ecastops.EcastOpSeed1
)

Cheers,
Pooja Falor

Thanks Pooja, that worked nicely :)