Select CRU, Sum (Quantite) From VINS V, RECOLTES R Where V.NUM = R.NVIN Group By CRU
From VINS V, RECOLTES R
Where V.NUM = R.NVIN
Group By CRU
Nombre de tuples : 61
ou bien
Select CRU, Sum (Quantite) From VINS V JOIN RECOLTES R ON (V.NUM = R.NVIN) Group By CRU
From VINS V JOIN RECOLTES R ON (V.NUM = R.NVIN)