select( count(distinct(a+b)) as DistinctAB, c3 from myTable group by C3 having DistinctAB > 1) -- to get all error cases - but this would not tell us a and b -

>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