joining two simular (but not identical tables)

From: Neil Dugan <postgres(at)butterflystitches(dot)com(dot)au>
To: pgsql-sql(at)postgresql(dot)org
Subject: joining two simular (but not identical tables)
Date: 2005-09-04 12:19:12
Message-ID: 1125836352.7221.7.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2005-09-04 13:00:31 Re: joining two simular (but not identical tables)
Previous Message Robert D. Kennedy 2005-09-03 18:50:02 Table Constraint CHECK(SELECT()) alternative?