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?
FROM property WHERE ListOfficeId = 340169