joining two simular (but not identical tables)
От | Neil Dugan |
---|---|
Тема | joining two simular (but not identical tables) |
Дата | |
Msg-id | 1125836352.7221.7.camel@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: joining two simular (but not identical tables)
|
Список | pgsql-sql |
I have two similar but not identical tables. I would like to create a view that combines the contents of both tables into a single view, where each record in each table is visible as a separate record in the view. table a Column | Type | Modifiers ---------------+-----------------------+-----------prcode | character varying(12) |descr | character varying(55)|rrp | numeric(10,5) |sugcusmkdn | numeric(6,2) |customerpr | numeric(7,2) |costpr | numeric(11,6) |lengths | character(1) |profitpercent | numeric(6,2) | table b Column | Type | Modifiers ---------------+-----------------------+-----------prcode | character varying(12) |descr | character varying(55)|rrp | numeric(10,5) |customerpr | numeric(7,2) |supdis | numeric(6,3) |costpr | numeric(11,6) |lengths | character(1) |profitpercent | numeric(6,2) |dnprice | numeric(7,2) |stcode | character varying(18) |dnprofit | numeric(5,2) | Thanks for any help. Regards Neil.
В списке pgsql-sql по дате отправления: