"Craig & Co." <crb_at_amsa.gov.au> wrote in message
news:41b4d3f8$0$29527$c30e37c6_at_ken-reader.news.telstra.net...
> "barry" <bbulsara23_at_hotmail.com> wrote in message
> news:747f1dec.0412060344.7116e3fb_at_posting.google.com...
> <snip>
> > ie, SELECT personName
> > FROM family
> > WHERE IN SAME FAMILY AS 'Brian'
> >
> > would return Mary, Bob, Joan, Brian, Peter, Claudine, Bruce, and
> > Francis but no one else.
> >
> > SELECT *
> > FROM personName
> > WHERE IN SAME FAMILY AS 'Claudine'
> >
> > should return the same results
> >
> > SELECT *
> > FROM personName
> > WHERE IN SAME FAMILY AS 'Dominic'
> >
> > should return Dominic and William and no one else.
> >
> <snip>
>
> Going by the sample data. I'm guessing you want a query similar to
> select familymember1, familymember2
> from family
> where familymember1 = 'Brian'
> or familymember2 = 'Brian'
>
> You could also do
> select familymember1, familymember2
> from family
> where familymember1 = '&&FamilyMember'
> or familymember2 = '&FamilyMember'
>
> Cheers
> Craig.
>
Are grandfathers, grandmothers & grandkids considered family member which
should be selected?
Received on Mon Dec 06 2004 - 17:52:49 CST
