Query Help

Hi

I have a test database with many columns Name1, Name2 .............and so on. Set out as follows:

Name1                           Name2
............................
Ridwan                           Nathaniel
Irfhan                              Koena

I need the data as follows:

Name3

Ridwan
Irfhan
Nathaniel
Koena

Plz Help....

Thanks in Advance..... :) Received on Wed Mar 22 2006 - 03:53:25 CST