TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Danish Habib
NA
694
245.7k
How To get the Result
Dec 29 2014 4:45 AM
I HAVE TWO TABLES in Which i have data i have no primary foreign key relationship between the tables But When i Write that below query
select A.QuestionTarget AS QTARGET,B.Question01Target,B.Question01Total
from QuestionTarget A INNER JOIN Answers B ON B.Question01=A.Question_ID
where A.Question_ID = B.Question01
It gives me two rows it gives me correct record set from First table and first row but in second row i do not have values there but due to the same id it insert the same rows record into the second row as well may b due to inner join what should i do
Reply
Answers (
5
)
SSIS Attaching File in SendMail Task.
query is not returning values