tags:

views:

29

answers:

1

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

A: 

Are you looking for an update or for a select statement?

Vixen
select statement will be awesome.thanks
Hi Ronald ..Am trying to simplify my query but can remove it from either table