My original table is like that:
ID A1 A2 A3 cnt
1234 1 0 0 4
1234 1 0 1 8
1234 1 1 1 5
1235 1 0 0 6
1235 1 0 1 7
1235 1 1 1 12
I have to create a new table B:
ID B1 B2 B3 S
1234 4 8 5 17
1235 6 7 12 25
The combination (A1=1,A2=0,A3=0) gives B1
The combination (A1=1,A2=0,A3=0) gives B2
The combination (A1=1,A2=1,A3=1) gives B3
S = B1+B2+B3
I think it's a classical problem, but i can't see to problem key
Thx,
Lhaj
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
