Re: Help writing SQL query

Daniel A. Morgan, University of Washington wrote:

> That is not what anyone has said to him. He posted a red herring ...
> not the actual design he is working with. He is apparently trying to
> move the data to a "better" design but hasn't shared that either.
>

There was no red herring here. I posted the design, only the data (the peoples names) was contrived. FYI the real scenario relates to a chemical database being migrated from Access to Oracle. The pairs of names in the family table are really pairs of atom numbers in a molecule. The relationship between them, two being on the same row in the table, represents a bond. I didn't put in the chemistry model as then I would have to explain how the connectivity is represented for SP3, SP2, SP, tautomeric bonds and salts etc which is not trivial. And there is much other data irrelevant to the problem at hand too. My family model is much simpler; the audience of this group will not be and do not have to be familiar with chemistry. Received on Wed Dec 08 2004 - 01:23:05 CST