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_at_pluto.downsfam.net>
>
> Is this necessarily a semijoin?
>
> Okay, but this doesn't address the namespace unification issues
> that I raised previously.
>
>
> Marshall
Date: Wed, 10 Aug 2005 22:09:17 -0400
Message-Id: <3hoqs2-tvg.ln1_at_pluto.downsfam.net>
Marshall Spight 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_at_(Sec)ure(Dat)a(.com)Received on Thu Aug 11 2005 - 04:09:17 CEST