Re: Help writing SQL query

From: Barry Bulsara <bbulsara23_at_hotmail.com>
Date: Tue, 7 Dec 2004 13:10:16 -0000
Message-ID: <1102425009.92771.0@doris.uk.clara.net>

Thank you Craig but you SQL only returns rows that have familymember 1 or 2 being Brian.

When I do a query on Brian, I want the whole family, ie Mary, Bob, Joan, Brian, Peter, Claudine, Bruce, Francis but NOT Dominic, William ...

Kind regards
Barry

"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.
>
> 

Received on Tue Dec 07 2004 - 07:10:16 CST