active-server-pages : Message: Re: SQL code for no dups?...NEVERMIND

active-server-pages · Active Server Pages Developers' List

Message search is now enhanced, find messages faster. Take it for a spin.

Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

SQL code for no dups?

Message #12370 of 12411 |

Re: SQL code for no dups?...NEVERMIND

As USUAL, the minute I ask, I remember/find the answer!<lol>

SELECT DISTINCT Address from Members ORDER BY Address

Dian ~

Sat Jun 7, 2008 9:03 pm

"Dian Chapman" <dian@...>

Offline

Message #12370 of 12411 |

Expand Messages	Author	Sort by Date
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...	Dian Chapman dianchapman	Jun 7, 2008 8:54 pm
As USUAL, the minute I ask, I remember/find the answer!<lol> SELECT DISTINCT Address from Members ORDER BY Address Dian ~...	Dian Chapman dianchapman	Jun 7, 2008 9:04 pm
SELECT * FROM MEMBERS WHERE ADDRESS IS NOT NULL ... From: active-server-pages@yahoogroups.com [mailto:active-server-pages@yahoogroups.com] On Behalf Of Dian...	Maria L Gaycheck rgaycheck	Jun 7, 2008 10:50 pm