Bill, SELECT DISTINCT document FROM table WHERE characteristic IN (a,b)
This can be done entirely with search action settings, or with a direct DBMS action. The tricky part, in either case, is getting your list of characteristics to be interpreted correctly by the DBMS. I use an array, with array attributes that make the commas come out correctly. By the way, this is an example like many I will show in the presentation I will be making at the San Diego Coroboree conference, on getting the most out of your DBMS. Bill On Thu, 10 Jul 2003 09:03:13 -0700, Bill Conlon wrote: > 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 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
