Re: O'Reilly interview with Date

From: Kenneth Downs <knode.wants.this_at_see.sigblock>
Date: Wed, 10 Aug 2005 22:09:17 -0400
Message-Id: <3hoqs2-tvg.ln1@pluto.downsfam.net>

Marshall Spight wrote:

> Kenneth Downs wrote:

>>
>> Joins can then be specified between two tables by specifying the
>> distinguishing features of the foreign key, and you can even leave out
>> this step if doing so will unambiguously pick the right one.
>>
>> So this:
>>
>> SELECT child.* from parent join child

>
> Is this necessarily a semijoin?

no, that's just what the fingers typed out. It is the same as any other query.

>
>

>> would be valid if there existed only one foreign between them.  If there
>> existed a myriad of keys and we chose to name the keys, we might do this:
>>
>> SELECT child.* from parent join child key KEYNAME

>
> Okay, but this doesn't address the namespace unification issues
> that I raised previously.
>
>
> Marshall

Why not?

-- 
Kenneth Downs
Secure Data Software, Inc.
(Ken)nneth@(Sec)ure(Dat)a(.com)

Received on Wed Aug 10 2005 - 21:09:17 CDT