Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: duplicate records
03-16-2010, 05:34 PM #1
- Join Date
- Apr 2008
- Thanked 0 Times in 0 Posts
Hi the below query returns the records i want but I also need it to return distinct values based upon one field.
I am using MSAccess
SELECT videovault.Path, ColourType.ColourPath, videovault.EffectType FROM ColourType INNER JOIN VideoVault ON ColourType.ColourName = VideoVault.EffectType WHERE videovault.productCode = 'J72673'
I have tried the distinct clause and group by function but it still returns the records with the field EffectType having duplicate entries.
Any ideas on what to do please?
Last edited by robert475; 03-16-2010 at 05:38 PM.