| 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? |