3 Replies Latest reply on Oct 7, 2007 4:37 PM by Dan Bracuk

    DISTINCT MySQL Issues

    Level 7
      I am trying to pull only one record per MLSNumber using DISTINCT for MySQL,
      but it isn't working. What am I doing wrong? Also, is there a way to pull
      the most recent record of the 2+ based on PostDate?

      Select
      DISTINCT(MLSNumber),PhotoURL,ListPrice,City,PropertyID,ListOfficeId,PropertyType
      FROM property WHERE ListOfficeId = 340169

      --
      Wally Kolcz
      MyNextPet.org
      Founder / Developer
      586.871.4126