La somme finale

CREATE TABLE R1 (a INTEGER, b INTEGER);

CREATE TABLE R2 (b INTEGER);

INSERT INTO R1 VALUES (1,1);

INSERT INTO R1 VALUES (2,1);

INSERT INTO R2 VALUES (1);

INSERT INTO R2 VALUES (2);

SELECT sum(R1.a) FROM R1, R2 WHERE R1.b=R2.b;