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@xxxxxxxxx] > Sent: Saturday, April 03, 2010 7:32 AM > To: rod@xxxxxx > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: join two tables without a key > > --- On Sat, 4/3/10, Raymond O'Donnell <rod@xxxxxx> wrote: > > > > From: Raymond O'Donnell <rod@xxxxxx> > Subject: Re: join two tables without a key > To: "Dino Vliet" <dino_vliet@xxxxxxxxx> > Cc: pgsql-general@xxxxxxxxxxxxxx > 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@xxxxxx > > > > Hi Ray, > > > > > > > > they don' t. It' s pure randomly generated data. > > > > > Brgds > > > > > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
