RSprinkel Posted December 20, 2006 Share Posted December 20, 2006 Hi all,I have a situation and the details are listed below.I have a scoring database that keeps track of scores for a racing league. The tables that I need to query to put on a standings page are Division, Drivers, and Score(which tracks all the races for all divisions and drivers. What I need is to be able to query these tables broken down into divisions and list each driver per division with their total standings. As it stands the Score table only list the drivers by their driver ID which is a number. So it would basically have to cross reference the ID in the Score table with the Driver table to get the drivers name. Then the points from each race has to be totalled for all drivers per division. Then the information queried goes into a standings table.For example:Pro DivisionDriver Name Total PointsJohn Doe 1180Any help with this would be MUCH APPRECIATED.Thanks Much in Advance. Quote Link to comment Share on other sites More sharing options...
fenway Posted December 20, 2006 Share Posted December 20, 2006 You'll need to post the table structures. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.