Hiya,
I have two tables and am using a LIKE wildcard to identify fields which are similar. I've used this successfully with other, smaller tables, but think I might be struggling due to the size of each on this occasion.
Table ACC_A has 19000 rows and Table CMS_A_LATEST has 10000.
The query I am using is as follows:
SELECT DISTINCT CMS_A_LATEST.CMS_ARTICLE_ID, CMS_A_LATEST.CMS_HEADWORD, ACC_A.HEADWORD AS ACC_HEADWORD, ACC_A.ID AS ACC_ARTICLE_ID
FROM CMA_A_LATEST, ACC_A
WHERE CMS_A_LATEST.CMS_HEADWORD LIKE "*" & ACC_A.HEADWORD & "*";
Is it the use of "SELECT DISTINCT" or simply the volume of data I'm asking the engine to compare that's causing the issue?
Are there any ways to make this query more efficient perhaps?
I'm still a real newbie to Access/SQL so completely accept I may be missing something obvious here!!
Many thanks in advance,
Chris