Re: join two tables without a key

Dino,

Not trying to be a "database purist" here, but...

If table A has no key, then why X,Y, and Z belong in one table?
And, table B has no key, then why P,Q, and R belong in one table?

And even more so, why are you trying to put X,Y,Z,P,Q,R into one table?
May be, if you tell us, what business entity/rule you are trying to
implement here, it'll be easier to help you.

Igor Neyman

> -----Original Message-----
> From: Dino Vliet [mailto:dino_vliet@yahoo.com]
> Sent: Saturday, April 03, 2010 7:32 AM
> To: rod@iol.ie
> Cc: pgsql-general@postgresql.org
> Subject: Re: join two tables without a key
>
> --- On Sat, 4/3/10, Raymond O'Donnell <rod@iol.ie> wrote:
>
>
>
>     From: Raymond O'Donnell <rod@iol.ie>
>     Subject: Re: [GENERAL] join two tables without a key
>     To: "Dino Vliet" <dino_vliet@yahoo.com>
>     Cc: pgsql-general@postgresql.org
>     Date: Saturday, April 3, 2010, 1:01 PM
>
>
>     On 03/04/2010 11:16, Dino Vliet wrote:
>
>     > Hi postgresql list, If I have two tables with the
> same number of rows
>     > but different columns and I want to create one table
> out of them what
>     > would be the way to do that in postgresql?
>     >
>     > Table A has N number of rows and columns X,Y,Z and
> Table B has N
>     > number of rows and P,Q,R as columns. None of the tables have a
>     > column which can be used as a key.
>     >
>     > The resulting table should have N number of rows and
> X,Y,Z,P,Q,R as
>     > columns.
>
>     How do the rows in the tables relate to each other? You
> need to decide
>     first how you match the rows in A and B.
>
>     Ray.
>
>
>     --
>     Raymond O'Donnell :: Galway :: Ireland
>     rod@iol.ie
>
>
>
> Hi Ray,
>
>
>
>
>
>
>
> they don' t. It' s pure randomly generated data.
>
>
>
>
> Brgds
>
>
>
>
>
>