USE tempdb;
GO
SET NOCOUNT ON;
GO
IF OBJECT_ID('T1') IS NOT NULL DROP TABLE T1;
GO
IF OBJECT_ID('T2') IS NOT NULL DROP TABLE T2;
GO
CREATE TABLE T1
(
 I INT NOT NULL,
 J INT NOT NULL,
 V INT NOT NULL
 CONSTRAINT pkT1 PRIMARY KEY(I,J)
);
GO
CREATE TABLE T2
(
 I INT NOT NULL,
 J INT NOT NULL,
 V INT NOT NULL
 CONSTRAINT pkT2 PRIMARY KEY(I,J)
);
GO
INSERT T1(I,J,V) VALUES( 1 , 1 , 0 );
INSERT T1(I,J,V) VALUES( 1 , 2 , 17 );
INSERT T1(I,J,V) VALUES( 1 , 3 , 11 );
INSERT T1(I,J,V) VALUES( 2 , 1 ,- 1 );
INSERT T1(I,J,V) VALUES( 2 , 2 ,- 1 );
INSERT T1(I,J,V) VALUES( 2 , 3 , 2 );
INSERT T1(I,J,V) VALUES( 3 , 1 , 1 );
INSERT T1(I,J,V) VALUES( 3 , 2 , 0 );
INSERT T1(I,J,V) VALUES( 3 , 3 , 0 );
GO
INSERT T2(I,J,V) VALUES( 1 , 1 , 0 );
INSERT T2(I,J,V) VALUES( 1 , 2 , 50 );
INSERT T2(I,J,V) VALUES( 1 , 3 , 1 );
INSERT T2(I,J,V) VALUES( 2 , 1 , 1 );
INSERT T2(I,J,V) VALUES( 2 , 2 , 0 );
INSERT T2(I,J,V) VALUES( 2 , 3 , 10 );
INSERT T2(I,J,V) VALUES( 3 , 1 , 1 );
INSERT T2(I,J,V) VALUES( 3 , 2 ,- 3 );
INSERT T2(I,J,V) VALUES( 3 , 3 , 5 );
GO
SELECT * FROM T1;
SELECT * FROM T2;
GO
SELECT T1.I, T2.J, SUM(T1.V*T2.V)
FROM T1 JOIN T2 ON T1.J = T2.I
GROUP BY T1.I, T2.J
ORDER BY T1.I, T2.J;
GO
/*
 0  17 11     0  50   1       28 -33 225
-1  -1  2  X  1   0  10   =    1 -56  -1
 1   0  0     1  -3   5        0  50   1
*/