Re: views and joins

From: Nicklas Karlsson <nicklas.karlsson_at_ineo>
Date: Mon, 04 Jun 2001 11:24:12 GMT
Message-ID: <wdKS6.122$3%.14368@read2.inet.fi>

> > VIEW V
> > ID DATA_A DATA_B
> > '123' 'a-data' 'b-data'
> > '12____4____' null 'b-data2'

Ooops, yes, that was a typo

> 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

Did you mean b.id_b here or am I wrong?

> FROM table_a a,
> table_b b
> WHERE a.id_a(+) = b.id_b

Thanks for the help, at least now it gives the correct result. It might get a little
complicated when the number of tables increase to 10-15 and the number of rows in the tables increase...

Received on Mon Jun 04 2001 - 06:24:12 CDT