Probaj ovako
Code:
UPDATE liga
SET Z =
(SELECT SUM(koseva_d)
FROM susreti
WHERE klub = domacin) +
(SELECT SUM(koseva_g)
FROM susreti
WHERE klub = gost)
,P =
(SELECT SUM(koseva_g)
FROM susreti
WHERE klub = domacin) +
(SELECT SUM(koseva_d)
FROM susreti
WHERE klub = gost)
__________________
Exception up = new Exception("Illegal operation.");
throw up;
|