Re: views and joins

Hi!

I guess/hope you actually mean:
>
> VIEW V
> ID DATA_A DATA_B
> '123' 'a-data' 'b-data'
> '12____4____' null 'b-data2'

Might be very slow, but try:

CREATE VIEW v_my_view
AS
SELECT a.id_a, a.data_a, b.data_b
FROM table_a a,

            table_b b
WHERE a.id_a = b.id_b(+)
UNION
SELECT a.id_a, a.data_a, b.data_b
FROM table_a a,

            table_b b
WHERE a.id_a(+) = b.id_b
/

Frank
Frank Received on Mon Jun 04 2001 - 05:25:18 CDT