Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Single view on multiple tables?
James,
Thanks! I don't care whether it is updateable because I'm trying to design it for a lookup anyway.
James Petts wrote:
> CREATE VIEW yourview (key, other_field_alias) AS
> SELECT key, other_field FROM parts_order_table
> UNION
> SELECT key, other_field FROM work_orders_table;
>
> Note that because this view contains a set operator (UNION) it is not
> updateable.
>
> James
>
--
Ken Rachynski
Database Analyst
krachyn_at_cadvision.com
<http://www.cadvision.com/krachyn>
ICQ: 3113514
Received on Fri Feb 19 1999 - 09:00:44 CST