Subqury don't working
Subqury don't working
Hello! I want to make next query:
SELECT
"c"."Фамилия" AS "Фамилия",
"c"."Имя" AS "Имя",
(SELECT COUNT(*) FROM "Bills" AS "b" WHERE "b"."Contact"="c"."CONTACTID") AS "COUNT"
FROM "Контакты" AS "c"
But i get next error - An unknown table or alias 'c' is specified in the SELECT query.
How I can make this query?
Thanks.