My table has 3 fields, A, B, and C. A & B form a compound PK, and C is initially empty.
There are exactly 4 values of B for each A. These 4 distinct values of B in each group are
listed in increasing order, and are taken from the set 1, 2, 3, 4, 5, 6, 7, 8.
My task is to fill column C with the values NOT taken from the set, listed in ASC order.
Column C is shown in its completed form below.
Any help with filling column C is greatly appreciated.
There are exactly 4 values of B for each A. These 4 distinct values of B in each group are
listed in increasing order, and are taken from the set 1, 2, 3, 4, 5, 6, 7, 8.
My task is to fill column C with the values NOT taken from the set, listed in ASC order.
Column C is shown in its completed form below.
Code:
A B C
----------------
1 1 2
1 3 5
1 4 6
1 7 8
2 2 1
2 3 5
2 4 6
2 8 7
3 4 1
3 5 2
3 7 3
3 8 6
...
Any help with filling column C is greatly appreciated.