Naomi,

Read my solution elsewhere in the thread.,

Walter,


>>
>>Look, you're turning the original problem into something else
>>
>>I have said ' I have no time for this'
>>I repeat: I won't be answering to you any more in this thread
>
>Greg,
>
>This is the original question.
>
>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
>
>------------------------
>Now, put
>
>c1 c2 c3 ...
>A a 1
>A b 2
>A b 3
>B c 4
>B d 4
>b d 4 && Just add this one line
>A b 3
>
>----------------------
>We now only want to return B c 4.
>
>This is the problem as I understood it and none of the proposed solutions solve it.