easy to solve mysql-query

[Anon]

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.

[Anon]

I think you have to include the table twice, like this:

select s.playerid, p.playerid from playertable as s, playertable as p, goaltable as g where g.playerid=p.playerid and g.passid=s.playerid;

I'm not 100% sure this will work but it could be worth a try.

:-)
Mitz.

[Anon]

Thats it, thanks. Now, that was so easy that I should have been able to solve it by myself. Well I'm lazy also :-) Panu