Danish Habib

Danish Habib

  • 1.4k
  • 694
  • 193k

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 

Answers (5)