| select Name
| from Table
| where GroupID in (1,7)
| group by Name
| having count(GroupID) = 2;
|
| This is brilliant, wish I'd thought of it :)
|
| Dave.
... But it doesn't solve the original question.
I quote this part from the original message:
"Basically, a person can have any number of attribute ID's (possibly even
the same one twice)."
Special emphasis on the "same one twice" which renders the technique above
flawed
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
