[rvg72]

[ QUOTE ]
I want to retrieve the VPIP of a player with playername = 'Caide' and player_id = 6.

I've tried:

SELECT * FROM compiledplayerresults WHERE compiledplayerresults_id = (SELECT compiledplayerresults_id FROM compiledresults WHERE player_id = 6)

But that didn't work because the inner select statements return several compiledplayerresults_id's. How do I handel this?

[/ QUOTE ]

pm sent