Im stuck on this for about half a day already…
Not sure what is the best way to achieve my goal…
Any attemt for help is appreciated !
I have ORDERS table with the [ LOCATION NAME ] column which contains duplicates.
What is the best way to filter the duplicates away ?
Additional table for Locations ?
Virtual Column ?
Thanks in advance !