>>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