merl

 can someone help me with getting started on query? i have 2 tables: team(team_id, name, other_crap) team_match(id,date,etc,winner_team_id,loser_team_id)

i'm trying to select everything from team as well as a count of results from team_match where winner_team_id=1

 the end results would be team.team_id, team.name, team.other_crap, count(team_match.winner_team_id) where team_match.winner_team_id=team.team_id