M
Mark via AccessMonster.com
Good day,
I am having a problem with a subquery and was wondering if there is a better
way to get the result needed. I have a table with customers and need to
exclude some of them based on a listing in a query that I created. The query
that I am trying to run is:
Select customer
From tablename
Where customer not in (Select customer from queryname)
The db times out when I run the query! The total number of records in table
(a) is 13135 and only (15) in the subquery (15).
Thank you in advance for the help provided.
I am having a problem with a subquery and was wondering if there is a better
way to get the result needed. I have a table with customers and need to
exclude some of them based on a listing in a query that I created. The query
that I am trying to run is:
Select customer
From tablename
Where customer not in (Select customer from queryname)
The db times out when I run the query! The total number of records in table
(a) is 13135 and only (15) in the subquery (15).
Thank you in advance for the help provided.