Re: Help writing SQL query

From: Craig & Co. <crb_at_amsa.gov.au>
Date: Tue, 7 Dec 2004 08:48:28 +1100
Message-ID: <41b4d3f8$0$29527$c30e37c6@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. Received on Mon Dec 06 2004 - 15:48:28 CST