Re: question on view

Try this:

create view my_view as
select tab1.fid, tab2.name from tab2, tab1 where tab2.fid (+) = tab1.fid;

Regards.

pradeep paudyal a écrit dans le message <37E7ACEE.2241CD58_at_evolv.com>...
>hello,
> I have a table which has fields called 'fid' and 'type'.
>I have another table which has fields 'fid' and 'name'.
>I want to create a view such that all the fid from the first table are
>listed with the name( if they have it ).In other words the second table
>has only fids which have names.
>But I want to have everything in the view and leave the 'name' field
>empty if a 'fid' doesn't have it.
>I coudn't think of how I can do it. Any help would be appreciated.
>Thanks
>Pradeep
>
>
Received on Wed Sep 22 1999 - 02:24:58 CDT