Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Johnyalm
Starting Member
49 Posts |
 Posted - 2005-09-02 : 06:06:46
|
| I have one table for a psychological test that holds general information about the test. For scoring on each dimension of the test there are another table.SotblTEST = general infotblSCORES = specific info scores for each dimensionNow I would like to search the tblTEST and then join tblSCORES - for EACH dimension and get ONE row for each taken test like this:tblTEST tblSCORE tblSCORE tblSCOREID test dim#1 dim#2 dim#31 / 45 / 34 / 212 / 34 / 23 / 34 3 / 45 / 23 / 24So for each ID in tblTESTS I have to do 3 selects in tblSCORE!Is there any way to do that?Johnywww.mirrorgate.com |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-09-02 : 06:28:48
|
| Post table structures, sample data and the result you wantMadhivananFailing to plan is Planning to fail |
 |
|
|
Johnyalm
Starting Member
49 Posts |
Posted - 2005-09-02 : 14:43:16
|
| OK, I will post the tablestructure and som examples tomorrow!www.mirrorgate.com |
|
|
|
|
|
|
Query to get one row result from many rows