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 create a table containing the ID (only one column
obviously) and all the other columns of both tables...
a simple equi join for each column is simple but how can I join
completely the two table on the bases of the column ID???
probably it is a simple question but I don't know how to solve this very
simple problem quikly... :-(
thanks
Ivan
select * from t1 full join t2 on (t1.id=t2.id);
you'll end up with the id column from both tables if you don't want
that you are going to need to list all the column names.
Peter.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
