>
>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.
But I think I just figured a solution in my head - and it's not that complex, after all.
If it's not broken, fix it until it is.
My Blog