How to join tables with different columns and different number of rows? - Mailing list pgsql-general

From Igor
Subject How to join tables with different columns and different number of rows?
Date
Msg-id 149919992.20010627130242@osb368.nnov.ru
Whole thread Raw
In response to Re: Complicated query... is there a simpler way?  (Richard Huxton <dev@archonet.com>)
List 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.



pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Complicated query... is there a simpler way?
Next
From: "Richard Huxton"
Date:
Subject: Re: How to join tables with different columns and different number of rows?