SELECT * FROM MEMBERS WHERE ADDRESS IS NOT NULL

-----Original Message-----
From: active-server-pages@yahoogroups.com
[mailto:active-server-pages@yahoogroups.com] On Behalf Of Dian Chapman
Sent: Saturday, June 07, 2008 3:55 PM
To: active-server-pages@yahoogroups.com
Subject: [ASP] SQL code for no dups?



Hi...

I can't remember/find the query command to not show duplicates in a
RecordSet. I need to query a DB, but only show one record for each
address. I THOUGHT it was the "group by", but that is giving me an
error?

How can I write this so only one entry for each address shows up?

RS.Open "SELECT * FROM Members ORDER BY Address", Conn, 1,3

I want the list to only show one entry for each address, versus what
I'm getting now, which is multiple addresses for every member from
that particular address.

TIA...

Dian ~







[Non-text portions of this message have been removed]