I did a search for this, but nothing is coming up although I'm positive this has been answered before. It probably just isn't obvious in the thread names and I've read a bunch of threads that don't quite answer my question.
What is the standard way to combine two columns and select the distinct values from the resulting fields? I ask for the standard way because I don't want to gerryrig my existing code to work if there is a more common, efficient means of doing this.
Speficially, I'm combining all of fields in columns keywords and keywords1, then selecting the distinct values in the result for use in a dropdown.
Thanks!
