bz.morvarid bz.morvarid - 4 months ago 15
SQL Question

copy values of two column of a table into a column from another table

I am going to have value of two columns from one table in a column of another table. I do not know correct code. Even for copying one column to another when I use this code, it just shows blank field in destination column.

insert into Send_RecCode(Send_RecName)
select (Sender)
from table1


Try This

INSERT INTO Send_RecCode(Send_RecName)
SELECT CONCAT(Sender, receiver) FROM table1