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
Suthish NairPosted Sep 10, 2013, 4:51 AM
Jignesh TrivediPosted Sep 10, 2013, 3:00 AM
hi,
first of all check whether your select query returns any result?
here also you are make inner join with inseted table it self it also might create problem...
hope this will help you.