sub query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

franky - 21 Nov 2005 20:11 GMT

I have a table called tblItems with a "itemDesc" text field. I aso have a
table called tblExcludeTheseWords. This table contains a list of words that
I would like to compare against the itemDesc field in tblItems and exclude
these records if a match is found in ANY part of itemDesc. How would I
accomplish this? I was trying somthing like this but its not working:

Select itemDesc from tblItems where itemDesc NOT IN (Select "ExcludeText"
from tblExcludeTheseWords)

Thanks in Advance!

Reply to this Message

John Spencer - 21 Nov 2005 21:47 GMT

This sounds like a case for a non-equi join.

SELECT Distinct ItemDesc
FROM tblItems LEFT JOIN tblExcludeTheseWords
ON tblItems.ItemDesc LIKE "*" & tblExcludeTheseWords.ExcludeText & "*"
WHERE tblExcludeTheseWords.ExcludeText is Null

>I have a table called tblItems with a "itemDesc" text field. I aso have a
> table called tblExcludeTheseWords. This table contains a list of words
[quoted text clipped - 7 lines]
>
> Thanks in Advance!

Reply to this Message