Post
Ask Question
Ramco Ramco

Ramco Ramco

  • 429
  • 3.5k
  • 567.9k

Aggregate function not allowed

Jan 28 2025 5:59 AM

Hi

  I have below query and i am getting error - Aggregate function not allowed

SELECT T1."TransId", Max(T1."RefDate") FROM OJDT T0  INNER JOIN JDT1 T1 ON T0."TransId" = T1."TransId" WHERE (Select Count(T1."BPLId") from JDT1 A1 where A1."TransId" = T1."TransId") > 0
group By T1."TransId"

Thanks


Answers (3)