Lol, your solution is much more effective than mine! Thanks :)
Gauthier ----- Original Message ----- From: "Bill Downall" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 11, 2003 1:41 PM Subject: Re: Witango-Talk: OT: SQL help > 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 > _____________________________________________________________________ > Envie de discuter en "live" avec vos amis ? T�l�charger MSN Messenger > http://www.ifrance.com/_reloc/m la 1�re messagerie instantan�e de France ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
