Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: NATURAL JOIN without join columbs

Re: NATURAL JOIN without join columbs

From: <lauri.pietarinen_at_atbusiness.com>
Date: 14 Mar 2005 01:35:26 -0800
Message-ID: <1110792926.431297.164140@l41g2000cwc.googlegroups.com>

Heikki Simperi wrote:
> What should happend in theory when two tables are joined by natural
and they
> do not have columns with same name?
>
>
> A (a,b,c)
> B (d,e)
>
> A |><| B
>
>
> Cartesian or empty or error?
>

It degenerates to a cartesian product.

regards,
Lauri Pietarinen Received on Mon Mar 14 2005 - 03:35:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US