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

Поиск
Список
Период
Сортировка
От Igor
Тема How to join tables with different columns and different number of rows?
Дата
Msg-id 149919992.20010627130242@osb368.nnov.ru
обсуждение исходный текст
Ответ на Re: Complicated query... is there a simpler way?  (Richard Huxton <dev@archonet.com>)
Список 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 по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Complicated query... is there a simpler way?
Следующее
От: "Richard Huxton"
Дата:
Сообщение: Re: How to join tables with different columns and different number of rows?