onedumbcoder Posted August 7, 2009 Share Posted August 7, 2009 lets say there is a team table that holders the name of the captain and than there is a team_players table that holds the information of all the players on that team. is there a way i can get the captains name and the number of players, and the information on all the players (name,age) in one query? Quote Link to comment Share on other sites More sharing options...
Maq Posted August 7, 2009 Share Posted August 7, 2009 is there a way i can get the captains name and the number of players in one query? Sure, you're going to have to use a JOIN. Can you post your table structure? 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.