Only way I can think of is to use a temp table:
CREATE TEMPORARY TABLE test (fruits varchar(100) not null) TYPE=HEAP;
INSERT INTO test SELECT DISTINCT fruits1 FROM table;
INSERT INTO test SELECT DISTINCT fruits2 FROM table;
SELECT DISTINCT fruits FROM test;
DROP TABLE test;
However this can be s
I have two columns in a table I need to get distinct values out of. I
know I can get distinct combinations of the values of the two columns with
"SELECT DISTINCT fruits1, fruits2" but what I need is unique values among
the two. So that if in fruits1 I have values "apples" and "oranges", an
