bz.morvarid bz.morvarid - 2 years ago 75
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

Answer Source

Try This

INSERT INTO Send_RecCode(Send_RecName)
SELECT CONCAT(Sender, receiver) FROM table1
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download