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