Re: Please help on SQL

From: Burnett <burnett_at_burnettms.demon.co.uk>
Date: 1998/03/25
Message-ID: <890864343.19871.0.nnrp-03.c1ed0717@news.demon.co.uk>#1/1

Try;

SELECT DISTINCT foo1.a, foo1.b
FROM foo f1,

                foo f2
WHERE
                f001.a = f002.a AND
                f001.b = f002.b AND
                f001.rowid != f002.rowid /* To prevent rows mathing them

selves */

The statement reads (in English)

Select foo column a and foo column b from foo where there is another row with an itdntial value of in column a and column b. Received on Wed Mar 25 1998 - 00:00:00 CST