How to copy one column into another column using SQL

SELECT DISTINCT T1.PROJECT_NAME ,
T1.REFERENCE_ID ,
T1.NAME AS URL1_title,
T1.URL AS URL1,
T1.REQUEST_TYPE ,
T2.VAL,
T3.VAL AS VAL1
FROM RIDW.VW_REQUEST T1
LEFT OUTER JOIN RICALM.VW_RQST_ STRING_EXT T2
ON T2.REQUEST_ID=T 1.REQUEST_ID AND T2.NAME='owner_ 1'
LEFT OUTER JOIN RICALM.VW_RQST_ STRING_EXT...