]>
> Sent: Wednesday, January 31, 2001 4:31 PM
> Subject: Selecting games which a given user can join
>
>
> > I have table that stores names of players and number of the game they play
> > (one player can play more games concurrently). Other users can join the
> >
6 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Selecting games which a given user can join
>
>
> select t2.id from gamers t1,games t2 where t1.user="jack" and
> t2.id<>t1.gid
> group by t2.id
>
> Original Message -
> From: zbynek <[EM
select t2.id from gamers t1,games t2 where t1.user="jack" and t2.id<>t1.gid
group by t2.id
Original Message -
From: zbynek <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 4:31 PM
Subject: Selecting games which a given user ca
Hi there!
I'm new to SQL and I can't figure out a query which would give me the result
I need. What I want to do is this:
I have table that stores names of players and number of the game they play
(one player can play more games concurrently). Other users can join the
game. For given user I want