Re: view for two tables (with blob)

Hi Isa,

you´re absolutely right and your select stmt is exactly what I need! I never saw this (+) before but it does a good job :-) Thanks for your help!

Regards,
Dirk

> If I have understood your question, you want all the colums of the
> table general_info and all the columns of the table my_blob, and the
> problem you have is than, when a id_gi has not a id_blob asociated,
> when you join the two tables, these records don´t appear.
>
> You can probe the next:
>
> create or replace view info_and_blob as
> select *
> from general_info a, my_blob b
> where a.id_myblob = b.id_blob(+);
>
> The option (+) will do these records appear.
Received on Thu Feb 20 2003 - 02:17:35 CST