Re: Please help on SQL

Try;

SELECT DISTINCT foo1.a, foo1.b
[Quoted] 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

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 CET