Copy all data in one field to another field of same table

[donmichel]

Hai all,
Is there a way to copy all rows from one field to another field in the same table? It is for reporting purpose. I have to use the following SQL for merging data from two different tables:
SELECT Comm_App_No,Cand_Name,WG FROM SSLC WHERE Choice1='1' OR Choice2='1' OR Choice3='1'
UNION
SELECT Comm_App_No,Cand_Name,WG FROM CBSE WHERE Choice1='1' OR Choice2='1' OR Choice3='1'
But the problem is WG should should get data from fields with different names in the two tables. Please help me.

[Neosoft Support]

Is there a way to copy all rows from one field to another field in the same table?

To copy from one field to another in the same table, you could try something like this:

Code: Select all

dbpFirst "DB" "Table"
Loop "1" "[DB.Table.$RecCount]" "[Counter]"
  SetVar "[DB.Table.Field2]" "[DB.Table.Field1]"
  dbpNext "DB" "Table"
EndLoop

[cp4w]

Is there a way to copy all rows from one field to another field in the same table?

Using SQL, something like this ( I don't remember the exact syntax )

Code: Select all

UPDATE
    TABLEX
SET
    COLUMNY = COLUMNZ;

[donmichel]

Both codes work perfectly well. Thanks a lot.