tags:

views:

29

answers:

1
Q: 

T-sql Query to update table

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  2010-09-10 13:01:15
select statement will be awesome.thanks
 2010-09-10 13:10:00
Hi Ronald ..Am trying to simplify my query but can remove it from either table
 2010-09-10 13:12:31

related questions

*= in Sybase SQL
sql missing rows when grouped by DAY, MONTH, YEAR
Adapt Replace all strings in all tables to work with text
Can you call a webservice from TSQL code?
How to tell the data types after executing a stored procedure?
C# - SQLClient - Simplest INSERT
SQL Server: Get data for only the past year
Get last item in a table - SQL
Is there a way to make a TSQL variable constant?
Create a database from another database?
SQL Server PIVOT examples?
What are some references, lessons and or best practices for SQL optimization training.
What's a good way to check if two datetimes are on the same calendar day in TSQL?
Trigger without a transaction?
How do I do an Upsert Into Table?
What is the easiest way using T-SQL / MS-SQL to append a string to existing table cells?
How do I avoid using cursors in Sybase (T-SQL)?
Best .NET Solution for Frequently Changed Database
T-Sql date format for seconds since last epoch / formatting for sqlite input
HOWTO - Compare a date string to datetime in SQL Server?
Differences Between MySql and MS SQL
Best method for varchar date validation in Sybase (T-SQL)?
interrogating table lock schemes in T-SQL
Testing for inequality in T-SQL
T-Sql Remove Decimal Point From Money Data Type