ADD DATA FROM 1 COLUMN TO OTHER

Hi

I have test table with three columns NAME, NAME2 and NAME3 :set out as follows:

NAME                    NAME2

ridwan                     thandeka
irfhan                       Jimmy

i need the data in a third column NAME 3 as follows:

NAME3 ridwan
irfhan
thandeka
jimmy

plz help....
thanks in advance... :) Received on Wed Mar 22 2006 - 05:13:05 CST