Re: SQL Syntax Query - sorry

Colin,

I think Peter with his query:

select familyid from (select distinct familyid, childname from family where childname in ('Robert','Rex')) group by familyid having count(*) = 2;

has the definitive answer. Let us know how it turns out for you.

Bert.

"Colin McGuire" <colinandkaren_at_lycos.co.uk> wrote in message news:ab6cea37.0212160635.7b985d40_at_posting.google.com...
> "Bert Bear" <bertbear_at_NOSPAMbertbear.net> wrote in message
news:<sObL9.2825
>
> > Will "FamilyID" and "Childname" be unique (e.g. able to be a composite
> > Primary Key?)?
> >
>
> Yes.
> Colin
Received on Mon Dec 16 2002 - 12:16:56 CST