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