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)
INSERT INTO Send_RecCode(Send_RecName) SELECT CONCAT(Sender, receiver) FROM table1