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: | Whole Thread | Raw Message | 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.
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? |