1
Answer

Incorrect Syntax near Distinct

Photo of Ramco Ramco

Ramco Ramco
1d
81
1

Hi

  Incorrect Syntax near distinct

WHEN T1."TransType" = '1470000049' THEN   (SELECT STRING_AGG(DISTINCT (A0."Location"), ', ')  FROM OITM A0  WHERE A0."ItemCode" IN (SELECT "ItemCode" FROM ACQ1 WHERE "DocEntry" = T1."CreatedBy" and "ObjType" = '1470000049' )))

Thanks

Answers (1)

Next Recommended Forum