Page 2 of 2

Posted: Wed Jan 25, 2006 5:23 am
by raghavan20
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)