Sql command does not give output

Question

Hi,

I have 2 tables, which are not have any primary key.

I want to add info field of one of the tables which contains 'no such name' string in it to other ones when 2 fileds of tables be the same

this is my code but it does not give any output.

INSERT INTO [p2p].[dbo].[salityv1$] ( info)

SELECT  [test123].[dbo].[salityv1] .["Info"]

FROM    [test123].[dbo].[salityv1]  Inner JOIN  [p2p].[dbo].[salityv1$] 

on   ([p2p].[dbo].[salityv1$].dport=53 and [test123].[dbo].[salityv1].["Source"] = [p2p].[dbo].[salityv1$].daddr AND [test123].[dbo].[salityv1].["Destination"] =[p2p].[dbo].[salityv1$].saddr and [test123].[dbo].[salityv1].["Info"] LIKE 'no such name%');

please help me,

Thanks in advance