> i require the dictinct values from (visualizing each column > result as a set) the union of the two columns
select distinct a as F from table union select distinct b as F from table; ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings