hello
I was able to get great help from the report forum a few days ago, and I'd like to try my luck again with a related problem.
In the table below, GroupID runs from 1 to 200. For each GroupID, there are exactly 4 values of Position, running from 1 to 4.
[tt]
GroupID Position V1 V2
1 1 67 79
1 2 115 77
1 3 81 2
1 4 56 29
2 1 11 53
2 2 91 8
2 3 13 109
2 4 88 13
3 1 97 67
3 2 44 115
3 3 17 81
3 4 22 56
..... ... .... ....
200 4 56 75
[/tt]
Notice that the 4 values of V1 having GroupID = 1 are identical (in value and in order) to the 4 values of V2 in Group3. So, I need SQL that outputs the GroupID values corresponding to these matches. In this case, the output would be...
[tt] G1 G2
1 3[/tt]
If there were, say, 12 such matches, then the query output would have 12 records.
Thanks in advance for any assistance.
Vicky C.
I was able to get great help from the report forum a few days ago, and I'd like to try my luck again with a related problem.
In the table below, GroupID runs from 1 to 200. For each GroupID, there are exactly 4 values of Position, running from 1 to 4.
[tt]
GroupID Position V1 V2
1 1 67 79
1 2 115 77
1 3 81 2
1 4 56 29
2 1 11 53
2 2 91 8
2 3 13 109
2 4 88 13
3 1 97 67
3 2 44 115
3 3 17 81
3 4 22 56
..... ... .... ....
200 4 56 75
[/tt]
Notice that the 4 values of V1 having GroupID = 1 are identical (in value and in order) to the 4 values of V2 in Group3. So, I need SQL that outputs the GroupID values corresponding to these matches. In this case, the output would be...
[tt] G1 G2
1 3[/tt]
If there were, say, 12 such matches, then the query output would have 12 records.
Thanks in advance for any assistance.
Vicky C.