Re: Single view on multiple tables?

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

On Thu, 18 Feb 1999 10:48:03 -0700, Ken Rachynski <krachyn_at_cadvision.com> wrote:

>Good day,
>
>I'm not sure if I have seen this done or not, but:
>
>I have several tables that hold different data with a similar key.
>Basically, I have a parts orders table with key values in the 60k range
>and a work orders table with key values in the 80k range, etc. I would
>like to create a view that displays the key value and another field that
>is common to all the tables. Is this possible?
>
>Thanks in advance for any answers.
Received on Fri Feb 19 1999 - 02:46:04 CST