[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

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

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) I would