ninedoors Posted March 16, 2010 Share Posted March 16, 2010 Is is possible do have a query get a SUM from 2 different tables in one query? I have created a database to hold hockey statistics for a league I play in. I have set up the database so that there are tables for scoring, penalties, games played (this is just a row with the player ID, team ID, and game ID, basically says this player played in this game), and a members table. What I would like to do is get a summary from all these tables so that I have the total penalty mins, goals and gamesplayed grouped by the player(id_member) which each table will have. Do I need a central table to link all these tables? My members table would work for this I think...... Thanks for the help. Nick Quote Link to comment Share on other sites More sharing options...
ninedoors Posted March 18, 2010 Author Share Posted March 18, 2010 I ended up just doing this with subquerys. 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.