Ann W. Harrison wrote:

> Err, if you group by the primary key, you're seldom going to find a
> group with more than one member. Here's an alternative:
>
> select a.noteid, a.folerid, b.noteid, b.folderid, a.subject
> from dbnotes a
> join dbnotes b on (a.subject = b.subject)
> where a.noteid < b.noteid
>

Oops, didn't even catch that one. Thanks. :-)

Woody (TMW)