I have 2 regular Tables "A" and "Q" and one junction table AQ dt looks like this;
A
* AID
* Adescription
* AScore
* Username
Q
* QID
* Qdescription
* Qpoint
AQ
* AID
* QID
* Username
I am looking for a tsql query that will help me update "AQ" to enable me output user performance base on their Answers ("A"Table) to Specific Questions("Q" table) Similar to this:
"User" | "Answer" | "Question"
user1 | A1 | Q1 user2 | A2 | Q1 user1 | A3 | Q2 user2 | A4 | Q2