Need help for writing a query

From: Khemraj DOOKHEE <kdookhee_at_capgemini.fr>
Date: Mon, 13 Nov 2000 13:07:51 +0100
Message-ID: <8uolds$gfh$1@s1.read.news.oleane.net>

Hi everyboby,

I've got a table named 'PLAYER_GAMES' with the following data structure : (PLAYER varchar2(10), GAME varchar2(25)). The table is filled as follows :

    PLAYER                        GAME
--------------------------------------------
    TOM                                FOOTBALL
    PETER                             BASKET-BALL
    PETER                             TENNIS
    PAUL                               VOLLEY-BALL
    PAUL                               TENNIS
    TOM                                BASKET-BALL
    TOM                                RUGBY
    STEVE                             FOOTBALL
    STEVE                             RUGBY

Can anyone help me in writing the query which gives the name of players who play BOTH football and rugby ?

Thanks in advance,
Khemraj. Received on Mon Nov 13 2000 - 06:07:51 CST