How create a view of 2 object-tables(One has REF attribute,the other has not)

Hi,
  I want to create a view connecting 2 object tables. Two tables like this.

• Customers table is of t_customer *******
• desc t_customer (object) id varchar2(5),name varchar2(10),address varchar2(30), tariff REF of t_tariff
• desc t_tariff (object) tariff_cde varchar2(5),tariff_desc varchar2(20)
• Customer2 table is of t_customer2 *******
• desc t_customer2 (object) id varchar2(5),name varchar2(10),address varchar2(30)

    and then I want to create a view over Customers and Customer2 like this.

    Create view customer_view of t_customer as     select a.id,a.name,a.address,a.tariff from customers a     union (select b.id,b.name,b.address,null

           from customer2 b)
    But !! it's error because Customer2 table has different number of attributes from Customers which in Customers has REF attribute but in Customer2 has not. How can I create a view like this? Thanks,
Pukky

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 17 1999 - 03:00:30 CDT