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_at_l41g2000cwc.googlegroups.com>
Date: 14 Mar 2005 01:35:26 -0800
Message-ID: <1110792926.431297.164140_at_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 - 10:35:26 CET