Bill looks to me like document one has characteristic a and d also or don't I understand what you are trying to say.
Select document from my table where characteristic = a and chart eristic = b should work for you but maybe I don't understand. -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com > From: Bill Conlon <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Thu, 10 Jul 2003 09:03:13 -0700 > To: <[EMAIL PROTECTED]> > Subject: Witango-Talk: OT: SQL help > > 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 > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
