Skip to Content
Former Member
Jun 09, 2016 at 12:56 PM

Make *SELECT return unique values


Hi experts

My SELECT statement returns a list which contains duplicates:


I understand in MS I could remove the duplicates with some SQL:

*SELECT(%DEPNACCS%,DEPNACC,AssetClass,"Calc=N AND DEPNACC in select distinct DEPNACC from AssetClass")

Is there a way to achieve the same thing with NW?