Re: Selecting games which a given user can join

2001-02-01 Thread Canadian Lumberer
]> > 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 > >

RE: Selecting games which a given user can join

2001-01-31 Thread Beasley, Julien
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

Re: Selecting games which a given user can join

2001-01-31 Thread Rus
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

Selecting games which a given user can join

2001-01-31 Thread zbynek
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