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

Make *SELECT return unique values

71 Views

Hi experts

My SELECT statement returns a list which contains duplicates:

*SELECT(%DEPNACCS%,DEPNACC,AssetClass,Calc=N)

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?