Hello,
I have a problem with my database.
I have records ( key =ID) which are gathered in different fields GROUP ( from “1ECC” to “8ECC” in this example).
Example: The IDs “14238” and “838b” are gathered in the GROUP “2ECC”
I would like to identify GROUPs where at least one ID has a link different from the links of the other IDs in the same GROUP.
Example:
The GROUP “1ECC” is made of 2 IDs which have the same LINK=”99”. The field RESULT of each ID is “A”.
The GROUP “5ECC” is made of 2 IDs which have different LINKs=”11” and “12”. The field RESULT of each ID is “B”.
The GROUP “6ECC” is made of 3 IDs of which one has a different LINK ( “0”) to the 2 others (“66”). The field RESULT of each ID is “B”.
This example is actually illustrating a bigger base, I therefore need to write something which repeats tests. Unfortunately I am too beginner and I do not know how to do it
Database: http://cjoint.com/?gcaSX28bUp
Result expected: http://cjoint.com/?gcaTL5cGFe
Can someone help me?
Thanks thousand times in advance