Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
  1. #1
    New Coder
    Join Date
    Apr 2008
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    duplicate records

    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

    Code:
    SELECT videovault.Path, ColourType.ColourPath, videovault.EffectType
    FROM ColourType
    INNER JOIN VideoVault ON ColourType.ColourName = VideoVault.EffectType
    WHERE videovault.productCode = 'J72673'
    There is a field called EffectType that needs to be distinct no matter what.

    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?

    Thanks
    Last edited by robert475; 03-16-2010 at 05:38 PM.


 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •