Ошибка в SQL коде

Question

SELECT DISTINCT COUNT (idSubscriber) 
    FROM (
        (SELECT idPlan, Communication_idCommunication
            FROM Plan
                WHERE Communication_idCommunication = 3 ) AS A
                INNER JOIN
                ( SELECT *
                    FROM Subscriptions) AS B ON A.idPlan = B.idPlan)

Вывод: ошибка:

1630 FUNCTION mylab.COUNT does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual  0.000 sec.

Что она значит?

Answer 1

SELECT COUNT(DISTINCT idSubscriber)
FROM (
  SELECT idPlan, Communication_idCommunication
  FROM Plan
  WHERE Communication_idCommunication = 3 
) AS A
INNER JOIN Subscriptions AS B ON A.idPlan = B.idPlan;

Проблема в пробеле между COUNT и (DISTINCT...

БЛОГ НА HUSL

Ошибка в SQL коде

Ответы (1 шт):