Aliases List

[Seitz333]

I would like to have a list of players that have an alais. I would like for the list to show their primary player name and their alais and for which site. I have been able to get a list of players that have an alais but I can't get it to show both their primary player neame and the alais. Any help would be great.

Thanks,
Chuck

[Seitz333]

After I played around with the SQL a little I was able to figure it out using this code:

Code: Select all

SELECT A.player_name as PokerStars, B.player_name as FullTilt
FROM player A, player B
WHERE B.id_player_alias = A.id_player AND b.id_player_alias > 0
ORDER BY A.player_name ASC