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 Link to comment https://forums.phpfreaks.com/topic/195468-is-this-possible/ 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. Link to comment https://forums.phpfreaks.com/topic/195468-is-this-possible/#findComment-1028132 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.