Re: join two tables without a key

Поиск
Список
Период
Сортировка
От Jeremy Harris
Тема Re: join two tables without a key
Дата
Msg-id 4BB720BC.4050001@wizmail.org
обсуждение исходный текст
Ответ на join two tables without a key  (Dino Vliet <dino_vliet@yahoo.com>)
Список pgsql-general
On 04/03/2010 11:16 AM, Dino Vliet wrote:
> If I have two tables with the same number of rows but different columns and I want to create one table out of them
whatwould be the way to do that in postgresql? 
>
>
>
> Table A has N number of rows and columns X,Y,Z and Table B has N number of rows and P,Q,R as columns. None of the
tableshave a column which can be used as a key. 
>
> The resulting table should have N number of rows and X,Y,Z,P,Q,R as columns.

You haven't said what you want the result to mean.

- Jeremy

В списке pgsql-general по дате отправления:

Предыдущее
От: Raymond O'Donnell
Дата:
Сообщение: Re: join two tables without a key
Следующее
От: Dino Vliet
Дата:
Сообщение: Re: join two tables without a key