I picked my SQL in the street, so it's kind of rudimentary. Maybe someone can point me in the right direction.
Here's a table document characteristic 1 a 1 b 1 d 2 a 2 d 2 e 3 a 3 b I want to SELECT the document(s) that match all of a set of characteristics. Say I want all documents with characteristic a AND b: This should return documents 1 and 3 Likewise, requesting characteristics a AND d returns documents 1 and 2 Say I request characteristics b AND d: I should get no rows. thanks Bill Conlon To the Point 345 California Avenue Suite 2 Palo Alto, CA 94306 office: 650.327.2175 fax: 650.329.8335 mobile: 650.906.9929 e-mail: mailto:[EMAIL PROTECTED] web: http://www.tothept.com ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
