Re: Help writing SQL query

>As this seems to be school work my recommendation is

and

> All of my students have at a minimum a BA or BS. Some have MA and MS and
> there have even been a few PhDs. Children? Hardly!

DANIEL, READ WHAT YOU HAVE WRITTEN, YOU SAID THIS LOOKED LIKE "SCHOOL" WORK, I SAID I WAS NOT. NOW ALL OF A SUDDEN WE HAVE GONE OFF ON SOME WEIRD TANGENT AND TALKING ABOUT UNIVERSITY GRADUATES WITH BA. AND BS. THE ISSUE AT HAND IS THAT I NEED SOME HELP COMPOSING AN SQL QUERY AND ALL YOU ARE DOING IS ATTEMPTING TO UNDERMINE ME. THIS IS A GENUINE PROBLEM AND I AM CANVASSING THE NEWSGROUP SUBSCRIBERS FOR SOME ASSISTANCE. So back to my original query, please please can someone in the group help me out. Repost below.
Barry
Original message follows:

Hi, I have inherited some information from an Access database in a terrible structure . All I want an SQL query, any version or Oracle, to return anyone in the same family as Mary, or Bob or, to Brian, or Beatrice, whoever...

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. Received on Tue Dec 07 2004 - 07:16:04 CST