show only one record from multiple results
Knowing there may be more than one way to acheive this, Im wodnering if the php pundits might point me toward more precise topics to search for a solution.
I created a search and results set of pages in dataassist then manually edited the sql to create a record set based on an inner join of two tables.
member and locations
Each member on the site has one unique member record, but can have many locations records. However on this particular search result I only want to show one record per memberid (the unique index of the join)
So although there may be 6 locations records for memberid 12 I only want to display on one record per memberid
I suspect I should add more code to the record set select statement that defines a count of memberid results, and returns only count # 1 of memberid
does it sound like im on the right train of thought?