Re: SQL query problem - can anyone help??

From: (wrong string) ño <"fjca.bcn"_at_mx3.redestb,es>
Date: 1998/01/16
Message-ID: <69n6d9$s42$1_at_talia.mad.ibernet.es>#1/1


Maybe this can be a solution:

select distinct part_sequence
from test p
where not exists (

    select part_name
    from test
    where

        part_sequence=72625 and
        part_name not in (
            select part_name
            from test
            where part_sequence=p.part_sequence
        )

)

I hope that be helpful for you.
Cheers,

Javier Received on Fri Jan 16 1998 - 00:00:00 CET

Original text of this message