how to insert value of column of a table to another?

Question

Hi,

I have 2 tables which are in diffrent database in sql server 2008.

I want if the condition below was ok, the info column is put in other column of table.

INSERT INTO [p2p].[dbo].[Utorrent] (info )

SELECT  info

FROM    [test123].[dbo].[123]

WHERE   ([test123].[dbo].[123].Source = [p2p].[dbo].[Utorrent].daddr AND Destination =[p2p].[dbo].[Utorrent].saddr And Info LIKE 'no such name%');

please help me