in my testtable

i have 4 rows when run without the distinct and 3 rows if i use the distinct keyword

what is exactly what it should return cause i have put 2x DEELREL With the same BASISREL.BRL_ID in it.

But we need to create a selection view for our planning team and they do not need the DEELREL Data at that point, thats why i want only the "Distinct" BASISREL returned here

In our dataschema there is ALWAYS AT LEAST 1 DEELREL for each BASISREL,

Wkr,

Eddy