Личный Блог, Ревекка Чигракова

базы данных
SELECT "workers"."id" as "id", SUM("work"."cash") as "pay"
FROM "workers", "work"
WHERE "workers"."id" = "work"."idworker"
GROUP BY "workers"."id"

работает, но

SELECT "workers"."name" as "name", SUM("work"."cash") as "pay"
FROM "workers", "work"
WHERE "workers"."id" = "work"."idworker"
GROUP BY "workers"."id"


почему нельзя по фамилии вывести?


(и нельзя ли в аську разговор перенести? ICQ 238-231)

GROUP BY ожидает те поля, которые указаны в SELECT, кроме участвующих в аггрегатных функциях.

SELECT "workers"."name" as "name", SUM("work"."cash") as "pay"
FROM "workers", "work"
WHERE "workers"."id" = "work"."idworker"
GROUP BY "workers"."name"


SELECT "workers"."id", "workers"."name" as "name", SUM("work"."cash") as "pay"
FROM "workers", "work"
WHERE "workers"."id" = "work"."idworker"
GROUP BY "workers"."id", "workers"."name"