Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 1 of 1 total |
Query Help |
Mon, Feb 16 2015 1:00 PM | Permanent Link |
Lance Rasmussen CDE Software Team Elevate | I'm not sure if I'm going to have to do in a couple queries or not, but assistance is appreciated.
STUDENTS ---------------- StudentID PK FirstName LastName QUIZPAIRINGS (Intersection) --------------------- STUDENTID1 PK STUDENTID2 PK TESTID PK bInRegularTest bInAdvancedTest SCORES ------------- StudentID PK TestID PK Score The object is to show the combined scores for the paired students who took the advanced test for test 101 sorted from highest to lowest combined score. Partner1, Partner 2, Partner 1 score, Partner 2 score, combined score 1) John Doe | Mary Doe | 400 | 399 | 799 2) Jenny Doe | Helen Doe | 300 | 340 | 740 3) Martin Doe | Greg Doe | 200 | 220 | 420 |
This web page was last updated on Wednesday, May 15, 2024 at 08:40 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |