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
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
Danish HabibPosted Dec 29, 2014, 11:03 PM
Danish HabibPosted Dec 29, 2014, 11:03 PM
Harieswaran DPosted Dec 29, 2014, 10:14 AM
Vikram AgrawalPosted Dec 29, 2014, 7:41 AM
Just remove the where clause and you will get desired result
Piyush PansuriyaPosted Dec 29, 2014, 7:28 AM
Try LEFT OUTER JOIN between these tables and remove WHERE clause.