Accessing Records from Two tables

Question

Dear All I have a Question about fetching the tables record Below is the details of my tables
1-Table)QuestionTarget:(QuestionID,QuestionTargetValue)
2-Table)AnswerTable:(AnswerID,Question01,Answer01,Question02,AnswerTwo,Question03,Answer03)

I already knows that the above database structure is quite bad as the answer table should have one row for each answer instead of a single row for all Question01,answer01,question02,answer02 --------

Question Target Table:

QuestionID, Question Target
1 22

Answer table

Answer ID Question01(this is id) QuestionTotal Question02(this is id of question2) Q2total
1 1 33 2 44

now above table shows that i have one row for all question like question 1,2,3----- so should i make all these as foreign key so that i will be able to fetch the records from both table, or what else.

How to fetch the target from QuestionTarget table and Answer from Answer table without joining

Thanks in advance

Danish Habib · Answer

Daer Khargesh Thanks for your response Actually in my one table I have the id's of Questions in separate rows i.e QuestionTarget Table: QUestionID QuestionTargetvalue 1 12 2 14 I have users in my system and the user have to give input against these targetvalues like 12 and 14 so i have an answer table there below is the structure of my answer table AnswerID Q1 A1 Q2 A2 Q3 A3 see the above table in that i am storing all the Q1Q2Q3 in a single row so should i make all these column as forign key to QuestionTarget table or what else i should do I have no many primary keys values (as foreign key in that answer table in single coulmn ) that is the issue

Khargesh Rajput · Answer

why do you want to fetch data without joining. you can use joining