Re: Outer Join & View

I believe Answer Set 2 is correct with respect to the standard because a view (strictly, a view definition) is a named query, that may for many purposes be used in the same way as a base table. Its value is the result of evaluating the query.

However, I would suggest the following additional tests on each system:

1. select * from V_2;
2. create table T_3 (Id_3 integer not null primary key, Desc_3 VARCHAR(6));

    insert into T_3 select V_Id_2 as Id_3, V_Desc_2 as Desc_3 from V_2;

    select T_1.Id_1, T_1.Desc_1, T_3.Id_3, T_3.Desc_3

      from T_1 left join T_3 on T_1.Id_1 = T_3.Id_3
     order by T_1.Id_1;

Cim Received on Sat Jun 15 2002 - 06:50:29 CEST