complex view question

From: Bob Skinner <bob_skinner_at_yahoo.com>
Date: 23 Sep 2002 15:55:22 -0700
Message-ID: <f30df007.0209231455.495331a2@posting.google.com>

Is it possible to combine two tables with similar columns (same data type and functional use, but perhaps different column names) into a single view?

Table A:

SKU        TYPE
-----      ------ 
B234        Book
C991        Magazine


Table B:
PROD_ID      TYPE
---------    ------
Z456          Book
D123          Newspaper


Desired View C:
V_SKU        V_TYPE
------       -------
B234          Book
C991          Magazine
Z456          Book
D123          Newspaper

What does the SQL to create this view look like? Is it even doable?

thanks,
Bob Skinner Received on Mon Sep 23 2002 - 17:55:22 CDT