tion1976
6th September 2023, 10:38
Hi all
I do not understand what is wrong in the SQL query i try to run from LN 10.7 BECS
SELECT DISTINCT
whinh521.adrn
from
whinh521
Error is:
ttadv3280m000: ttadv31832 : Execute Query: Table not present in query: DISTINCT

OmeLuuk
6th September 2023, 10:46
ttadv3180 is too limited in its syntax. Try to select the field without distinct, use the field as sort field and in the generated report use the "before.field.whinh521.adrn" instead.

tion1976
6th September 2023, 12:22
Thanks. At least I have some explanation.