Re: [GENERAL] join two tables without a key

2010-04-05 Thread Igor Neyman
> Subject: Re: join two tables without a key > > --- On Sat, 4/3/10, Raymond O'Donnell wrote: > > > > From: Raymond O'Donnell > Subject: Re: [GENERAL] join two tables without a key > To: "Dino Vliet" >

Re: [GENERAL] join two tables without a key

2010-04-03 Thread Andreas Kretschmer
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 num

Re: [GENERAL] join two tables without a key

2010-04-03 Thread Raymond O'Donnell
On 03/04/2010 12:32, Dino Vliet wrote: > --- On Sat, 4/3/10, Raymond O'Donnell wrote: > 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

Re: [GENERAL] join two tables without a key

2010-04-03 Thread Dino Vliet
--- On Sat, 4/3/10, Raymond O'Donnell wrote: From: Raymond O'Donnell Subject: Re: [GENERAL] join two tables without a key To: "Dino Vliet" Cc: pgsql-general@postgresql.org Date: Saturday, April 3, 2010, 1:01 PM On 03/04/2010 11:16, Dino Vliet wrote: > Hi postgresql lis

Re: [GENERAL] join two tables without a key

2010-04-03 Thread Jeremy Harris
On 04/03/2010 11:16 AM, Dino Vliet wrote: 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,

Re: [GENERAL] join two tables without a key

2010-04-03 Thread Raymond O'Donnell
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

[GENERAL] join two tables without a key

2010-04-03 Thread Dino Vliet
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