Re: Need help for writing a query

Sorry,

I forgot to mention that the query should be able to give the name of players who play all of the games found in a list, where the list would be something like : ('GAME1', 'GAME2', 'GAME3', ..., 'xxx').

Thanks,
Khemraj.

"Khemraj DOOKHEE" <kdookhee_at_capgemini.fr> a écrit dans le message news: 8uolds$gfh$1_at_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 - 07:37:08 CST