How to join tables with different columns and different number of rows?

From: Igor <dbmanager(at)osb368(dot)nnov(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: How to join tables with different columns and different number of rows?
Date: 2001-06-27 09:02:42
Message-ID: 149919992.20010627130242@osb368.nnov.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

What SQL query will help me to concatenate two different tables
with different number of rows? For example , i have first table
with column1 and column2 , having 3 rows , and second table
with column3, column4 , having 5 rows. How to make
third table with column1,column2,column3,column4 and 5 rows in it
(and last two rows in column1 and column2 are empty)

Thanks for sugestions

Igor.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2001-06-27 09:43:35 Re: How to join tables with different columns and different number of rows?
Previous Message Gunnar Rønning 2001-06-27 07:12:04 Re: Blobs in PostgreSQL