Posted: Wed Jan 25, 2006 5:23 am
Finally, I found the easiest and best way to do it....
Code: Select all
mysql> select company from test1
-> union
-> select name from test1
-> order by 1 asc
-> ;
+-----------+
| company |
+-----------+
| gg |
| google |
| microsoft |
| msft |
| yahoo |
| yh |
+-----------+
6 rows in set (1.70 sec)