Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Tricky : SELECT N-to-N "ALL or NOTHING" (please read in)
OK, I found a kind of answer. First I added a column "count" to StructuredCategories : S1,C1,2 S1,C2,2 S2,C1,2 S2,C3,2 S3,C2,2 S3,C3,2 And I my request is now : SELECT * FROM StructuredCategories WHERE (cid=C1 OR cid=c2) group by sid having count(sid) = count It works but if you find a better...- LePoulpe
- Post #2
- Forum: -General database discussion
-
Tricky : SELECT N-to-N "ALL or NOTHING" (please read in)
Hi, Sorry for the title but I can't find the right words. Don't hesitate to suggest a better one ... :-) Here is my problem : I got 2 tables. First one is "Categories" (with a CID as primary key) and second one is "StructuresCategories" (with SCID, CID as primary key). The main idea is that a...- LePoulpe
- Thread
- Replies: 2
- Forum: -General database discussion
