J
JonoB
I have a select distinct query as follows:
SELECT DISTINCT [MergeString] FROM qryMergeTime
Whilst this does return the right records (i,e. only shows unique records in
the [MergeString] field, it doesnt show all the fields that I need to see,
i.e. the SELECT DISTINCT function needs to run on the [MergeString] field,
but I want to see the results from the [FullString] field.
So, what I have done is as follows:
SELECT DISTINCT [FullString]
FROM qryMergeTime
WHERE [MergeString] In (SELECT DISTINCT [MergeString] FROM qryMergeTime);
However, as I am working with a relatively large dataset (few hundred
thousand records), the query takes a long time to run.
Any ideas on how I can improve this?
Many thanks for your help.
SELECT DISTINCT [MergeString] FROM qryMergeTime
Whilst this does return the right records (i,e. only shows unique records in
the [MergeString] field, it doesnt show all the fields that I need to see,
i.e. the SELECT DISTINCT function needs to run on the [MergeString] field,
but I want to see the results from the [FullString] field.
So, what I have done is as follows:
SELECT DISTINCT [FullString]
FROM qryMergeTime
WHERE [MergeString] In (SELECT DISTINCT [MergeString] FROM qryMergeTime);
However, as I am working with a relatively large dataset (few hundred
thousand records), the query takes a long time to run.
Any ideas on how I can improve this?
Many thanks for your help.