macromedia.coldfusion.advanced_techniques
[Top] [All Lists]

DISTINCT MySQL Issues

Subject: DISTINCT MySQL Issues
From: "Adobe Forums"
Date: Sat, 6 Oct 2007 15:07:26 -0400
Newsgroups: macromedia.coldfusion.advanced_techniques

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 



<Prev in Thread] Current Thread [Next in Thread>