Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
Sql command does not give output
diamond diamond
Sep 8 2013 7:42 AM
1k
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Master Table and Transaction Table
Making QUErY from stored procedure to SQL