Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL: views and joins
> A fellow named Frank posted the code to answer this but he apparently
> failed to get it hooked to the thread. What you want is an outer join
> which basically means "I want every row in A plus those rows in B that
> match the join condition". In Oracle the outer join is represented by
> '(+)' which you place on the table that you want to force to return a
> null row when it does not match the driving table it is being matched
> against.
>
> select a.*, b.*
> from table_a A, table_b B
> where a.key = b.key(+)
>
> will result in every row in A being returned (subject to additional
> where clause conditions). Nulls are returned for the B table columns
> where there is not matching row in B for the A join column values.
Yeps, got that part working. Now I am wondering how that solution scales If I was to add a table C with the same structure in the same way to the view. Any ideas? Received on Tue Jun 05 2001 - 04:03:52 CDT