Scratch the previous answer - I see the problem now. Will answer when I come to work.

>>>Hi All,
>>>
>>>I have a SQL problem I have no idea if I can solve it with one select (I can do with two, but this is not what i like to have)
>>>
>>>The problems comes from an import scenario.
>>>
>>>I have a table like
>>>

>>>c1   c2  c3 ...
>>>A    a    1
>>>A    b    2
>>>A    b    3
>>>B    c    4
>>>B    d    4
>>>A    b    3
>>>

>>>
>>>For a given c3 the combination of c1 and c2 should be the same. We can see that for c3=4 this is not true.
>>>
>>>How do I code a single SELECT SQL that returns just
>>>
>>>

>>>c1   c2  c3
>>>B    c    4
>>>B    d    4
>>>

>>>
>>>and
>>>
>>>

>>>c3
>>>4
>>>

>>>
>>>
>>>TIA
>>>
>>>Agnes
>>
>>
>>

>>SELECT *;
>>FROM YourTable;
>>INNER JOIN YourTable Tbl1 ON YourTable.C3 = Tbl1.C3 AND;
>>                             (YourTable.C1 # Tbl1.C1 OR YourTable.C2 # Tbl1.C2);
>>INTO CURSOR crsErrors
>>BROW NORMAL
>>

>>NOT TESTED!
>
>
>
>Look at the output if you add another combination for B : B e 4
>>c1 c2 c3 ...
>>A a 1
>>A b 2
>>A b 3
>>B c 4
>>B d 4
> B e 4
>>A b 3