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_vl...@yahoo.com] 
> Sent: Saturday, April 03, 2010 7:32 AM
> To: r...@iol.ie
> Cc: pgsql-general@postgresql.org
> Subject: Re: join two tables without a key
> 
> --- On Sat, 4/3/10, Raymond O'Donnell <r...@iol.ie> wrote:
> 
> 
> 
>       From: Raymond O'Donnell <r...@iol.ie>
>       Subject: Re: [GENERAL] join two tables without a key
>       To: "Dino Vliet" <dino_vl...@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
>       r...@iol.ie
> 
> 
> 
> Hi Ray,
> 
> 
> 
> 
> 
> 
> 
> they don' t. It' s pure randomly generated data. 
> 
> 
> 
> 
> Brgds
> 
> 
> 
> 
> 
> 

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to