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", and
in fruits2 I have values "bananas" and "oranges", my query will return
values "apples", "oranges", "bananas".
Any ideas how this can be done?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
