Re: [SQL] join a lot of columns of two tables

2006-12-14 Thread Ragnar
On fim, 2006-12-14 at 12:01 +0100, ivan marchesini wrote: > Dear Postgres Users, > I have 2 tables... > each one has a column called ID (primary keys of each table) > the values into each ID column are exactly the same. > > each table has a lot of other columns (around 50 for each table) > >

Re: [SQL] join a lot of columns of two tables

2006-12-14 Thread Peter Childs
On 14/12/06, ivan marchesini <[EMAIL PROTECTED]> wrote: Dear Postgres Users, I have 2 tables... each one has a column called ID (primary keys of each table) the values into each ID column are exactly the same. each table has a lot of other columns (around 50 for each table) I would like to

[SQL] join a lot of columns of two tables

2006-12-14 Thread ivan marchesini
Dear Postgres Users, I have 2 tables... each one has a column called ID (primary keys of each table) the values into each ID column are exactly the same. each table has a lot of other columns (around 50 for each table) I would like to create a table containing the ID (only one column obviousl