Re: Documentation for 8.*

Christian Wapenhans wrote:
> Hello,
>
> i've to optimize a sql statement for a customer. There are inner join and
> join.
>
> Is there any documentation which I can read in order to know how to do it.
>
> The statement from an mssql server doesn't work.
>
> The Problem:
>
> tab1:
> id1
> name1
>
> tab2:
> id2
> name2
>
> tab3:
> id3
> id1
> id2
>
> I need all name1s from tab1 which are empty. That means no id2 exist for
> id1.
>
> The whole problem is bigger. But this part is the problem, because there
> are 3,000,000 entry in tab2 and tab3 and 100,000 entries in tab1.
>
> The orcale version ist something like 8.0
>
>
>
> Bye from Wunstorf, Germany
> Christian
>

I don't intend to be too negative here but every indication from your post is that you are lacking the skills to be successful. You MUST know the exact version number.

Go to http://www.psoug.org
click on Morgan's Library
click on Joins

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)