Lines Matching refs:C
27 C INTEGER NOT NULL,
33 PRIMARY KEY (B, C, D));
37 C INTEGER NOT NULL,
38 PRIMARY KEY (A, B, C));
40 INSERT INTO T2(A, B, C) VALUES(702118,16183,15527);
41 INSERT INTO T2(A, B, C) VALUES(702118,16183,15560);
42 INSERT INTO T2(A, B, C) VALUES(702118,16183,15561);
43 INSERT INTO T2(A, B, C) VALUES(702118,16183,15563);
44 INSERT INTO T2(A, B, C) VALUES(702118,16183,15564);
45 INSERT INTO T2(A, B, C) VALUES(702118,16183,15566);
46 INSERT INTO T2(A, B, C) VALUES(702118,16183,15567);
47 INSERT INTO T2(A, B, C) VALUES(702118,16183,15569);
48 INSERT INTO T2(A, B, C) VALUES(702118,16183,15612);
49 INSERT INTO T2(A, B, C) VALUES(702118,16183,15613);
50 INSERT INTO T2(A, B, C) VALUES(702118,16183,15638);
51 INSERT INTO T2(A, B, C) VALUES(702118,16183,15681);
52 INSERT INTO T2(A, B, C) VALUES(702118,16183,15682);
54 INSERT INTO T1(B, C, D, E, F, G, H) VALUES(16183,15527,6,0,5,5,0);
55 INSERT INTO T1(B, C, D, E, F, G, H) VALUES(16183,15560,6,0,5,2,0);
56 INSERT INTO T1(B, C, D, E, F, G, H) VALUES(16183,15561,6,0,5,2,0);
57 INSERT INTO T1(B, C, D, E, F, G, H) VALUES(16183,15563,6,0,5,2,0);
58 INSERT INTO T1(B, C, D, E, F, G, H) VALUES(16183,15564,6,0,5,2,0);
59 INSERT INTO T1(B, C, D, E, F, G, H) VALUES(16183,15566,6,0,5,2,0);
60 INSERT INTO T1(B, C, D, E, F, G, H) VALUES(16183,15567,6,0,5,2,0);
61 INSERT INTO T1(B, C, D, E, F, G, H) VALUES(16183,15569,6,0,5,2,0);
62 INSERT INTO T1(B, C, D, E, F, G, H) VALUES(16183,15612,6,0,5,5,0);
63 INSERT INTO T1(B, C, D, E, F, G, H) VALUES(16183,15613,6,0,5,2,0);
64 INSERT INTO T1(B, C, D, E, F, G, H) VALUES(16183,15638,6,0,5,2,0);
65 INSERT INTO T1(B, C, D, E, F, G, H) VALUES(16183,15681,6,0,5,5,0);
66 INSERT INTO T1(B, C, D, E, F, G, H) VALUES(16183,15682,6,0,5,2,0);
71 SELECT T2.A, T2.B, T1.D, T1.E, T1.F, T1.G, T1.H, MAX(T1.C), '^'
74 AND T1.C = T2.C
81 SELECT T2.A, T2.B, T1.D, T1.E, T1.F, T1.G, T1.H, MAX(T1.C), '^'
84 AND T1.C = T2.C