RE: Selecting games which a given user can join

2001-01-31 Thread Beasley, Julien
That's what I would have suggested as well, but I tried that on a test table and it returned all t2.id's in t2. Julien Beasley Bridge News Asia Applications Specialist > -Original Message- > From: Rus [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, February 01, 2001 10:26 AM > To: [EMAIL P

AND on a many to many table, with arbitrary ANDs

2001-01-30 Thread Beasley, Julien
Hello everyone, I am in the process of building a search engine on a database. I have two tables that have a many-to-many relationship: A story table and a category table. Story Table: --- id | story| --- 1 | Alice in Wonderland 2 | Peter Pan 3 | Pokemon's adventure 4 | Tale