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.