Likes CAT and Sport Query 
Author Message
 Likes CAT and Sport Query

Try this on this problem:

SELECT DISTINCT Test.Likes, Test.ID, Test_1.Likes, Test_1.ID
FROM Test Test, TEST Test_1
WHERE (Test.Likes='CAT') AND (Test_1.Likes='SPORT') AND
(Test.ID=Test_1.ID)

This creates a self join on the table and returns the two records (in
one row set) that likes both CAT and SPORT and will not return the
record who Likes SPORT only.

Rick Clark



Tue, 06 Apr 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Shared cat

2. Good example of Electronic Cat wanted

3. To the terrorists attacking rec.pets.cats.misc

4. REPOST: Please desist trolling rec.pets.cats.misc

5. Schroedinger's Cat - New Internet-based Programming Project Forum

6. Cats!

7. Skin this cat

8. Has anyone made any sports games in QB?

9. Sports facility booking databse

10. Le sport : c'est notre domaine !

11. wanted: sports scheduler

 

 
Powered by phpBB® Forum Software