[SQL] join a lot of columns of two tables

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

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

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

Re: [SQL] join and sort on 'best match'

hi pls tell me if table *Item 3 : news, nature, greenpeace, whale has all clmn y v need join ??* *Ashish* On 12/13/06, Ragnar [EMAIL PROTECTED] wrote: On mið, 2006-12-13 at 10:26 +0100, Dirk Griffioen wrote: I have been breaking my head on the following problem: how to join 2

Re: [SQL] join and sort on 'best match'

Hi, Ashish, Ashish Ahlawat [EMAIL PROTECTED] wrote: hi pls tell me if table *Item 3 : news, nature, greenpeace, whale has all clmn y v need join ??* Please try to write in English, so we can understand and answer your questions. Regards, Markus -- Markus Schaber | Logical