Perhaps you need experiment with "Having"?
-----Original Message-----
From: [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
To: Multiple recipients of list database <[EMAIL PROTECTED]>
Date: Thursday, 4 November 1999 09:20
Subject: [DUG-DB]: A tricky SQL problem
>
>
>Hi, I have a tricky SQL problem (you may have guessed that from the subject
>heading :) that is beyond my SQL ability. And it only involves one table.
>
>Here is a simplified example table:
>
>Name AttributeID
>
>Bob 5
>Bob 3
>Bob 11
>Jim 5
>Jim 7
>Alice 8
>Alice 5
>Alice 11
>
>Basically, a person can have any number of attribute ID's (possibly even
the
>same one twice). The query goes something like this: "Find me all the names
that
>have records for AttributeID 5 and for AttributeID 11" where the 5 and the
11
>will change depending on what the user is searching for. The example query
only
>required 2 attributeID's to exist, but there is in fact no limit.
>
>I'm guessing that some kind of tricky sub-query or exists clause is needed
but
>every time I try and formulate it it escapes me.
>
>Phil.
>
>
>---------------------------------------------------------------------------
> New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
