easy to solve mysql-query

wxdqz

New Member
I try to do a query that selects information from two tables. I try to fetch information on a person who scored a goal and the person who gave the pass to that goal.persons are idetified in "players" table with player id. Question: how do I construct the query to be able to fetch playername and the name of the player who gave the pass.player table: playerid, playername. goaltable: playerid, passid.I haven't been able to get both names selected in the same query. The problem is that I use the same table for the scorer and the passer.
 
Back
Top