How To get the Result

Question

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

Danish Habib · Answer

I am getting this record set QuestionTarget QuestionTotal 47 12(this is correct) 57 12(in second row 57 is correct but 12 is comming from above line) and i want to get the one question target then how can i dont use where clause

Danish Habib · Answer

I am getting this record set QuestionTarget QuestionTotal 47 12(this is correct) 57 12(in second row 57 is correct but 12 is comming from above line) and i want to get the one question target then how can i dont use where clause

Harishsady D · Answer

in this scenario try using sub query... it will avoid duplicate ...

Vikram Agrawal · Answer

Hi danish Just remove the where clause and you will get desired result

Piyush Pansuriya · Answer

Hi Danish Try LEFT OUTER JOIN between these tables and remove WHERE clause.