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